oracle分页有通用写法,假设一页5行 select * from ( select t.*,rownum from ( select * from table1 where condition order by column) t
) where rownum>(pangeNow-1)*5 and rownum<=(pageNow)*5 如果基础查询不需要排序,可以省掉一层嵌套 select * from ( select t.*,rownum from table1 t where condition ) where rownum>(pangeNow-1)*5 and rownum<=(pageNow)*5