<p class="coding">/SQL
[Oracle] Median 중간값 구하기
daisy26
2023. 9. 8. 17:05
Median을 구하라는 문제가 나와서 어떻게 구현해야 할까 뇌에 힘 빡줬는데, 오라클은 Median 함수가 있었다.
후-하!
https://www.hackerrank.com/challenges/weather-observation-station-20/problem?isFullScreen=true
Weather Observation Station 20 | HackerRank
Query the median of Northern Latitudes in STATION and round to 4 decimal places.
www.hackerrank.com
SELECT ROUND(MEDIAN(LAT_N),4)
FROM STATION