Oracle SQL: How to Fetch Row Numbers 5 To 10
This SQL query will fetch row numbers 5 to 10 using rownum
You will get the same result if you remove where condition from inner query:
SELECT * FROM
(SELECT ROWNUM ROWNO,S.* FROM STUDENTS S
)
WHERE ROWNO BETWEEN 5 AND 10