This SQL query will fetch row numbers 5 to 10 using rownumYou 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
コメント