先排序获取新的行号后才能分页,否则行号会与排序冲突,导致结果不理想
select * from (select rownum , t.* from (select * from table order by oid desc) ) where rownum <10 and rownum >0;