[HackerRank/Oracle] Weather Observation Station 20

📌문제링크 풀이참고

*풀이참고 링크 들어가셔셔 보시면 됩니다.

1. ROW_NUMBER 이용

1 2 3 4 5 6

SELECT ROUND(AVG(LAT_N),4) MEDIAN FROM (SELECT LAT_N, ROW_NUMBER() OVER(ORDER BY LAT_N) RN, COUNT(1) OVER() +1 CNT FROM STATION) WHERE RN BETWEEN FLOOR(CNT/2) AND CEIL(CNT/2);

2.MEDIAN 함수 이용

SELECT  ROUND(MEDIAN(LAT_N),4)
FROM    STATION;