oracle分页:select * from ( select t.*,rownum from ( select * from table1 where condition order by column) t ) where rownum>(pangeNow-1)*5 and rownum<=(pageNow)*5
使用rownum 多层嵌套
用rownum来取31到40行