oracle分页处理,oracle 中分页的处理

[注意]

1、rownum 不能直接使用> .

2、需要先排序，过滤以后再处理rownum

i、minus

这个方法因为用到了minus操作符，所以速度会受影响

select rownum,c1.* from (select t.* from carrier t where .... order by...) c1 where rownum <= 8

minus

select rownum,c2.* from (select t.* from carrier t where .... order by...) c2 where rownum <= 8

ii、select嵌套(3层)。

SELECT *

FROM (SELECT rownum rownumber, c.*

FROM (

select t.* from carrier t where .... order by .. .

) c

) cc

WHERE cc.rownumber > 8

and cc.rownumber <= 10