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