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

  • doprakenny
     + 0 comments
    select round(a.LAT_N,4) from
(Select 
row_number() over (order by LAT_N) rw_nm,
LAT_N from STATION) a
where a.rw_nm in 
(floor(((select count(*)total_rws from STATION)+1)/2),
CEIL(((select count(*)total_rws from STATION)+1)/2));