[Oracle] ROWNUM

ROWNUM

오라클에서 조회된 행이 몇번째 행인지 부여

SELECT * FROM MEMBER;

SELECT * FROM MEMBER WHERE ROWNUM BETWEEN 1 AND 5;

---

ROWNUM을 활용하기 위해 서브쿼리 이용

SELECT * FROM 
(SELECT ROWNUM NUM, MEMBER.* FROM MEMBER)
WHERE NUM BETWEEN 6 AND 10;