select t.* from (select t.rowid,rownum rn from (select * from users) t where rownum < 9980 ) t wehre t.rn > 9000030
select * from users where rowid in (select rid from (select rowid as rid, row_number() over(order by null) as rn from users where id > 2000) where rn between 9980 and 10000);
select * from users where rowid in (select rid from ( select rowid as rid, rownum as rn from users where id > 2000) where rn between 9980 and 10000);
select t.* from (select rid from (select rowid rid rownum rn from users) t where rownum < 9000010 ) t wehre t.rn > 9000030
select t.* from (select t.*,row_number() over(order by null) orderNumber from Users t where id > 2000) t where orderNumber between 9980 and 10000;