oracle sql 分页 几百万数据

转载▼

select * from (select rownum r, a.* from (select * from  table_name order by ndatetime desc ) a where rownum <= currentPage * pageSize ) where r > (currentPage - 1) * pageSize

 

currentPage:跳至第几页

pageSize:一页显示多少条