oracle分页

oracle中的分页

select * from
    (select rownum r,e1.*
     from (select * from emp order by sal) e1
    where rownum<=8)
    where r>=5;
简化
select * from (select ROWNUM rn, c.* from code c where rownum < 16) t where t.rn >= 10;

 

 其中要注意，rownum大于是找不到结果的，返回结果为空，我们需要查询之后为rownum定义别名之后在查询才可以。