언어

median: percent_rank

땅호720 2024. 6. 12. 13:03
with cte as (
select *,
    percent_rank() over (order by lat_n) pr\
from station
)

select round(
lat_n,
4)
from cte
where pr =0.5
저작자표시 비영리 변경금지 (새창열림)