oracel分页

select * from (select a1.*,rownum rn from (

xx

) a1 where rownum <=5) where rn>=2;

原文地址:https://www.cnblogs.com/zfzf1/p/7489499.html