oracel分页

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

xx

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

posted @ 2017-09-07 14:21  zfzf1  阅读(120)  评论(0编辑  收藏  举报