oracle分页

在oracle 下面想了4总方法

minus差分页

select * from table where rownum<=10 minus select * from table where rownum<=5

rownum伪列

select * from (select rownum tid,t.* from table t where rownum<=10) where tid<=10 and tid>=5

notin相反

select * from table where id not in(select id from table where rownum<=5) and rownum<=5

前题是id排序的select * from table where id>(select max(id) from table where rownum<=5) and rownum<=5