Oracle分页

select * from
(
select emp.*,rownum as rn
from
(
select*from emp
)emp
where rownum<=9
)
where rn>=7