We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 20
Weather Observation Station 20
Sort by
recency
|
3526 Discussions
|
Please Login in order to post a comment
WITH CTE AS( SELECT LAT_N, ROW_NUMBER() OVER (ORDER BY LAT_N ASC) AS RN, COUNT(*) OVER () AS CNT FROM STATION) SELECT ROUND(LAT_N, 4) FROM CTE WHERE RN=(CNT + 1)/2
WITH numbered_station AS ( SELECT lat_n, ROW_NUMBER() OVER (ORDER BY lat_n DESC) AS row_num FROM station ) SELECT ROUND(lat_n, 4) AS rounded_lat_n_median FROM numbered_station WHERE row_num = (SELECT MAX(row_num) FROM numbered_station) / 2;
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);