Resultset Paging & Performance increase using ROWNUM

[sonaliak]

SELECT *
FROM table1
WHERE conditon AND
rownum<200
MINUS
SELECT *
FROM table1
WHERE conditon AND
rownum<100

This will do it for rownum100 to 200.
Is this what you were looking for ?

Sonali