You are viewing a single comment's thread. Return to all comments →
WITH indexed AS( SELECT LAT_N , ROW_NUMBER() OVER(ORDER BY LAT_N ASC) AS idx FROM STATION )
SELECT ROUND(LAT_N, 4) FROM indexed WHERE idx = ( SELECT COUNT(LAT_N) FROM STATION ) / 2
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 →
WITH indexed AS( SELECT LAT_N , ROW_NUMBER() OVER(ORDER BY LAT_N ASC) AS idx FROM STATION )
SELECT ROUND(LAT_N, 4) FROM indexed WHERE idx = ( SELECT COUNT(LAT_N) FROM STATION ) / 2