You are viewing a single comment's thread. Return to all comments →
MySQL:
WITH med AS( SELECT LAT_N, ROW_NUMBER() over (ORDER BY LAT_N) as RN FROM STATION)
SELECT round(lat_n,4) FROM med WHERE rn = (SELECT round((max(rn)/2),0) FROM med)
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 →
MySQL:
WITH med AS( SELECT LAT_N, ROW_NUMBER() over (ORDER BY LAT_N) as RN FROM STATION)
SELECT round(lat_n,4) FROM med WHERE rn = (SELECT round((max(rn)/2),0) FROM med)