You are viewing a single comment's thread. Return to all comments →
it is easy to understand
with cte as ( select lat_n,row_number() over(order by lat_n) as rasc ,row_number() over(order by lat_n desc) as rdesc from station ) select CAST(lat_n AS DECIMAL(7, 4)) from cte where abs(rasc-rdesc)<=1 order by lat_n
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 →
it is easy to understand