You are viewing a single comment's thread. Return to all comments →
WITH CTE as ( Select LAT_N, ABS(ROW_NUMBER() OVER (Order By LAT_N) - ROW_NUMBER() OVER (Order By LAT_N desc)) ROW# FROM STATION)
Select CAST(AVG(LAT_N) as decimal(38,4)) from CTE WHERE ROW# in (Select MIN(ROW#) From CTE);
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 CTE as ( Select LAT_N, ABS(ROW_NUMBER() OVER (Order By LAT_N) - ROW_NUMBER() OVER (Order By LAT_N desc)) ROW# FROM STATION)
Select CAST(AVG(LAT_N) as decimal(38,4)) from CTE WHERE ROW# in (Select MIN(ROW#) From CTE);