You are viewing a single comment's thread. Return to all comments →
WITH CTE AS ( SELECT LAT_N, ROW_NUMBER() OVER(ORDER BY LAT_N) AS R_NUM, COUNT(*) OVER() AS C_N FROM STATION ) SELECT ROUND(CONVERT(DECIMAL(10, 4), LAT_N), 4) FROM CTE WHERE R_NUM=(C_N+1)/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 →