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.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Weather Observation Station 20
  5. Discussions

Weather Observation Station 20

  • RA1711003010075
     + 0 comments

    medium is not a function in built so better use this

    select cast(lat_n as decimal(10,4)) from (select lat_n, row_number() over (order by lat_n desc) as rnum1 from station) t1 where rnum1 = (select case when max(rnum)%2=0 then max(rnum)/2 else max(rnum)/2+1 end from (select row_number() over (order by lat_n desc) as rnum from station) t)