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 ROW_NUM FROM STATION )
SELECT ROUND(LAT_N,4) FROM CTE Where ROW_NUM = (Select CEIL((COUNT(ID)/2)) 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 →
Given below logic is correct, please suggest
With CTE As ( SELECT LAT_N ,ROW_NUMBER() OVER(ORDER BY LAT_N) AS ROW_NUM FROM STATION )
SELECT ROUND(LAT_N,4) FROM CTE Where ROW_NUM = (Select CEIL((COUNT(ID)/2)) From Station);