You are viewing a single comment's thread. Return to all comments →
Simplest answer I could find:
select distinct convert( decimal(16,4), percentile_disc(0.5) within group(order by lat_n) over() ) from station;
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 20
You are viewing a single comment's thread. Return to all comments →
Simplest answer I could find:
select distinct convert( decimal(16,4), percentile_disc(0.5) within group(order by lat_n) over() ) from station;