oracle分页查询

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

===========================================

select * from (select t.*,rownum rn from (select * from s_user order by id) t where rownum<=100) where rn>=1