본문 바로가기
언어

median: percent_rank

by 땅호720 2024. 6. 12.
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

'언어' 카테고리의 다른 글

basic join: top competitors (medium)  (1) 2024.06.14
basic join: the report (medium)  (0) 2024.06.13
Manhattan Distance  (0) 2024.06.11
수입 1등은 몇 명인가  (0) 2024.06.11
round, ceil, floor, truncate  (0) 2024.06.11