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 |