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

  • AnimeGeek32
     + 2 comments

    Thanks! I used that solution and modified it for this problem:

    set @rownum = 0;
select round(avg(t1.lat_n), 4) as median_val
from (
    select @rownum := @rownum + 1 as row_number, s.lat_n
    from station s, (select @rownum := 0) r
    order by s.lat_n
) as t1,
(
    select count(*) as total_rows
    from station
) as t2
where t1.row_number in (floor((total_rows + 1) / 2), floor((total_rows + 2) / 2));