SELECT ROWNUM, E.*
FROM EMP E
ORDER BY E.SAL DESC; -- CTRL + ENTER : 쿼리실행
SELECT ROWNUM, T.*
FROM (SELECT *
FROM EMP
ORDER BY SAL DESC) T;
SELECT *
FROM (SELECT ROWNUM AS RNUM, T.*
FROM (SELECT *
FROM EMP
ORDER BY SAL DESC) T)
WHERE RNUM >=5 AND RNUM <=7;
