oracle实现分页

oracle实现的原理是用oracle自带的rownum来实现，先用子查询查询出rownum 再通过between来实现

---

select
    *
from
    ( select emp.*,rownum as aaa from emp/*表名*/ ) t
where
    t.aaa between 5 and 10 

---

 希望能帮到各位小伙伴