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
|
3991 Discussions
|
Please Login in order to post a comment
SELECT ROUND(LAT_N,4) FROM (SELECT LAT_N, ROW_NUMBER() OVER(ORDER BY LAT_N ASC) AS Row_Number_Asc, ROW_NUMBER() OVER(ORDER BY LAT_N DESC) AS Row_Number_Desc FROM STATION) st WHERE st.Row_Number_Asc = st.Row_Number_Desc
SELECT ROUND(AVG(middle.LAT_N), 4) FROM ( SELECT LAT_N, ROW_NUMBER() OVER (ORDER BY LAT_N) AS rn, COUNT(*) OVER () AS total_count FROM STATION ) AS middle WHERE rn IN (FLOOR((total_count + 1) / 2), CEIL((total_count + 1) / 2));
WITH CTE_ABC AS ( SELECT LAT_N, ROW_NUMBER() OVER (ORDER BY LAT_N ASC) AS row_asc, ROW_NUMBER() OVER (ORDER BY LAT_N DESC) AS row_desc FROM STATION
) SELECT ROUND(AVG(LAT_N),4) AS median FROM CTE_ABC WHERE row_asc = row_desc OR row_asc = row_desc - 1 ;
MS SQL
select distinct cast( PERCENTILE_DISC (0.5) WITHIN GROUP (order by lat_n) OVER () as decimal(10,4)) AS MedianCont from station
SELECT ROUND(AVG(LAT_N), 4) AS median FROM ( SELECT LAT_N, ROW_NUMBER() OVER (ORDER BY LAT_N) AS rn, COUNT(*) OVER () AS total_count FROM STATION ) t WHERE rn IN (FLOOR((total_count + 1) / 2), CEIL((total_count + 1) / 2));