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

다음 문제를 풀어보세요.

다음 중 아래 EMP 테이블 데이터를 기반으로 수행한 SQL의 결과 건수가 다른 하나를 고르시오.

[EMP 테이블 데이터]

SELECT * FROM (SELECT ENAME, SAL, ROW_NUMBER() OVER (ORDER BY SAL DESC) AS R FROM EMP) WHERE R <= 2;

SELECT * FROM (SELECT ENAME, SAL, RANK() OVER (ORDER BY SAL DESC) AS R FROM EMP) WHERE R <= 2;

SELECT * FROM (SELECT ENAME, SAL, DENSE_RANK() OVER (ORDER BY SAL DESC) AS R FROM EMP) WHERE R <= 2;

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