SQLD CBT 기출문제 예상문제 954번

다음 문제를 풀어보세요.

다음 보기 중 실행결과 값이 다른 SQL을 고르시오.

SELECT EMPNO, ENAME
FROM ( SELECT ENAME, SAL 
       FROM   EMP 
       ORDER BY SAL DESC )
WHERE ROWNUM <= 3;

SELECT EMPNO, ENAME
FROM   EMP
HERE   ROWNUM <= 3
ORDER BY SAL DESC;

SELECT EMPNO, ENAME
FROM ( SELECT E.*, 
              ROW_NUMBER() OVER (ORDER BY SAL DESC) as RNK
              FROM EMP E ) E
WHERE RNK <= 3;

SELECT EMPNO, ENAME
FROM   EMP 
ORDER BY SAL DESC
FETCH FIRST 3 ROWS ONLY