Orcale 三层嵌套分页代码
select * from
(
select emp.*,rownum a from
(
select * from emp
) emp where rownum<7
) where a>3
select * from
(
select emp.*,rownum a from
(
select * from emp
) emp where rownum<7
) where a>3