You are viewing a single comment's thread. Return to all comments →
Mysql solution using percent_rank()
select round(lat_n,4) from (select lat_n, percent_rank() over (order by lat_n) as quart from station) as temp where quart=0.5 order by lat_n limit 1;
can be also done using ntile()
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 →
Mysql solution using percent_rank()
#select round(lat_n,4) from (select lat_n, percent_rank() over (order by lat_n) as quart from station) as temp where quart=0.5 order by lat_n limit 1;
#can be also done using ntile()