oracel分页

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

xx

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

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