Question

orcale里 子查询语句里不能使用order by id desc 怎么办？

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 怎么办？

请高手指点！

Answer 1

select * from (select * from database where rownum <=10 and id>all(select adviseId from database where rownum <=0)) A order by A.id desc