oracle分页的方式,Oracle分页的两种方式

第一种:

select b.*

from (select rownum as rid, a.* from om_cm_book_hotword a) b

where b.rid <= 10

and b.rid > 5;

第二种:

select c.*

from (select rownum as rid, b.*

from (select a.* from om_cm_book_hotword a) b

where rownum <= 10) c

where rid > 5

因为rownum 的位置不同，第二种相对于第一种增加了一层嵌套查询。

举例:

select *

from (select rownum as rid, b.*

from (select *

from T_MEMBERIMPORT a

where a.importdate <=

to_date(#enddate#, 'yyyy/MM/dd hh24:mi:ss')

and a.importdate >=

to_date(#begindate#, 'yyyy/MM/dd hh24:mi:ss')) b

where rownum <= #PageNow# * 10) c

where rid > (#PageNow#  - 1) * 10

select *

from (select rownum as rid, b.*

from (select * from t_vvip

name=#name#

companyname=#companyname#

order by id     ) b

where  #PageNow# * 10>= rownum ) c

where rid> (#PageNow#  - 1) * 10