时间:2021-07-01 10:21:17 帮助过:7人阅读
列表
代码:
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_lat
from station;
SQL 查询中位数,并保留四位小数
标签:val value tle count and images ima 查询 技术