꿈라CBT아래 EMP 테이블에서 SAL 상위 5순위 사원을 조회하는 SQL 로 옳은 것은?
보기
[EMP 테이블]
| EMPNO | ENAME | SAL |
|---|---|---|
| 7839 | KING | 5000 |
| 7902 | FORD | 3000 |
| 7788 | SCOTT | 3000 |
| 7566 | JONES | 2975 |
| 7698 | BLAKE | 2850 |
| 7782 | CLARK | 2450 |
| 7499 | ALLEN | 1600 |
| 7521 | WARD | 1250 |
| 7654 | MARTIN | 1250 |
| 7934 | MILLER | 1300 |
- 1SELECT * FROM EMP WHERE ROWNUM <= 5 ORDER BY SAL DESC;
- 2SELECT DISTINCT SAL FROM EMP ORDER BY SAL DESC;
- 3SELECT * FROM (SELECT * FROM EMP ORDER BY SAL DESC) WHERE ROWNUM <= 5;
- 4SELECT * FROM EMP FETCH FIRST 5 ROWS ONLY;