oracle分页有通用写法,假设一页6行 select * from ( select t.*,rownum from ( select * from table1 where 条件 order by column) t ) where rownum>(pangeNow-1)*6 and rownum<=(pageNow)*6
rownum 为oracle关键字,表示数据条数
oracle分页有通用写法,假设一页6行 select * from ( select t.*,rownum from ( select * from table1 where 条件 order by column) t ) where rownum>(pangeNow-1)*6 and rownum<=(pageNow)*6
rownum 为oracle关键字,表示数据条数