orcale里 子查询语句里不能使用order by id desc 怎么办?我要做个id倒序的分页查询select * from database where rownum <=10 and id>all(select adviseId from database where rownum <=0) order by id这样能实现分页 但是id是从小到大我要实现从大到小的 !可是子查询语句里不能使用order by id desc 怎么办?请高手指点!