SELECT * FROM table WHERE ROWNUM< 10;

SELECT * FROM table WHERE ROWNUM >90 AND ROWNUM< 100;

SELECT * FROM table WHERE ROWNUM< 101; 

minus 

SELECT * FROM table WHERE ROWNUM< 91;