oracle分页sql语句

select * from(select a1.*, rownum.rn from(select *from emp) a1 where rownum<=10) where rn>=6;

  

select * from(select a1.*, rownum.rn from(select *from emp) a1 where rownum<=10) where rn>=6;

 

posted @ 2016-05-21 23:08  IT温故而知新  阅读(110)  评论(0编辑  收藏  举报