[注意]
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