oracle 分页

select *
  from (select b.*,rownum a from (select * from 表名) b)
 where a between 5 and 10;

转载于:https://www.cnblogs.com/mengyihui666666/p/3628831.html