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;
✅ @miawoo, I gave you an upvote on your post! Please give me a follow and I will give you a follow in return and possible future votes!
Thank you in advance!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice one
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
good~
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit