SQLD · 제61회 · 43번

Question

다음 중 SAL(연봉)이 높은 순서로 상위 2명을 조회하는 SQL로 가장 적절한 것은?

Accepted Answer

SELECT EMP_ID FROM (SELECT * FROM EMP ORDER BY SAL DESC) WHERE ROWNUM <= 2;

Answer

SELECT EMP_ID FROM EMP ORDER BY SAL DESC;

Answer

SELECT EMP_ID, ROW_NUMBER() OVER (ORDER BY SAL DESC) AS RN FROM EMP WHERE RN <= 2;

Answer

SELECT EMP_ID FROM EMP WHERE ROWNUM <= 2 ORDER BY SAL DESC;