三层嵌套分页 

select t2.* from ( select t1.*,rownum rn from (select id from employee) t1 where rownum <= ? ) t2 where rn > ?

 

posted @ 2017-03-20 10:31  岁月淡忘了谁  阅读(559)  评论(0)  编辑  收藏  举报