[Oracle SQL] SELECT 실습_ ROWNUM

[Oracle SQL] SELECT 실습_ ROWNUM

I ROWNUM

▶ 각각의 ROW에 부여된 상대적인 번호

1. ROWNUM Check

1) Rownum 부여

---

SELECT ROWNUM,ENAME,DEPTNO,SAL FROM EMP;

---

2) Rownum 특징 확인

---

SELECT ROWNUM,ENAME,DEPTNO,SAL FROM EMP ORDER BY DEPTNO,SAL;

---

▶ 최상위 급여자 5명 조회 SQL문

---

SELECT ROWNUM,DEPTNO,ENAME,SAL

FROM (

    SELECT DEPTNO,ENAME,SAL

    FROM EMP

    ORDER BY SAL DESC

    )

WHERE ROWNUM <= 5;

---