ORACLE三层嵌套分页查询

select * from account where rowid in(select rid from (select rownum rn,rid from(select rowid rid,create_date from
account order by create_date desc) where rownum<10) where rn>0) order by create_date desc;