全部博文
-
编辑 删除
oracle数据库下的分页查询
常规的分页思路： select * from (select a.*, rownum as rnum from (select * from burgess) a where rownum <=5300) where rnum >= 5000 有较高效率的分页思路 select * from (select * from (select b.*, row_number() OVER(ORDER BY null) AS "row_number" from burgess b) p where p."row_number" > 500
