我建议用rowid来实现分页。给你个小例子: select /*+FIRST_ROWS*/ * from t where rowid in ( select rid from ( select rownum rno,rowid rid from ( select rowid from t where category = 20 order by category,product_name ) where rownum <= 5000 ) where rno >= 4981 )
nowait(独行天涯路) 的方法的确好。只是他写的语句有个小问题,要改为 select /*+FIRST_ROWS*/ * from t where rowid in ( select rid from ( select rownum rno,rid from ( select rowid rid from t where category = 20 order by category,product_name ) where rownum <= 5000 ) where rno >= 4981 )
select /*+FIRST_ROWS*/ * from t
where rowid in
( select rid from
( select rownum rno,rowid rid from
( select rowid from t
where category = 20
order by category,product_name
) where rownum <= 5000
) where rno >= 4981
)
select /*+FIRST_ROWS*/ * from t
where rowid in
( select rid from
( select rownum rno,rid from
( select rowid rid from t
where category = 20
order by category,product_name
) where rownum <= 5000
) where rno >= 4981
)