Skip to content

Instantly share code, notes, and snippets.

@GGrassiant

GGrassiant/A. SQL MEDIAN QUERY.md

Last active March 18, 2021 14:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save GGrassiant/dae10bf01c12472d6a93363ac4658f60 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save GGrassiant/dae10bf01c12472d6a93363ac4658f60 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Median Query
Raw
median.sql
Select round(S.LAT_N,4) median
from station S
where (
select count(Lat_N)
from station
where Lat_N < S.LAT_N )
= (
select count(Lat_N)
from station
where Lat_N > S.LAT_N)
-- Select the item that has as many items before than after
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment