oracle 排序+分页查询sql

oracle的查询较蛋疼，需嵌套2个子查询

select * from (Select aaa,rownum rn from (Select * From tb Where aaa='803' order by bbb desc) order by bbb desc) where rn>0 and rn<=1000 order by bbb desc