列表
代码：
select distinct round(nth_value(lat_n,(select round(count(lat_n)/2) from station))
over (order by lat_n asc RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING),4) as median_latfrom station;本文共 255 字，大约阅读时间需要 1 分钟。
列表
代码：
select distinct round(nth_value(lat_n,(select round(count(lat_n)/2) from station))
over (order by lat_n asc RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING),4) as median_latfrom station;转载于:https://www.cnblogs.com/Angella/p/6701544.html