To display rows 11 to 20, construct a query like this: SELECT * FROM tt WHERE rowid in ( SELECT rowid FROM tt WHERE rownum <= 20 MINUS SELECT rowid FROM tt WHERE rownum < 11);
Another one:
select * from (select rownum rn,tt.* from tt) a where a.rn between 11 and 20;
FROM tt
WHERE rowid in (
SELECT rowid FROM tt
WHERE rownum <= 20
MINUS
SELECT rowid FROM tt
WHERE rownum < 11);
select * from (select rownum rn,tt.* from tt) a
where a.rn between 11 and 20;