分页

select * from (select  ID ,rownum rn from table) where rn>=10 and rn<=15;

原文地址:https://www.cnblogs.com/shuihaya/p/4015274.html