Question

jsp+oracel分页查询语句问题？

select * from DSGB_comment where ID IN (select ID from (select rownum as numrow,ID from DSGB_comment) where numrow > "+ spage +" and numrow < "+ (ipage * pages) +") order by TIME Desc
以上是我的sql语句，我想把数据按照时间的降序来排列，每页显示10条数据，这10条数据是从数据库里把最新录入的数据按数据时间降序排列，但结果是这10条数据是从数据库里把最旧的数据按时间降序排列的，请问这个sql语句改怎么改？

Answer 1

应该在最里面的查询进行排序，sql如下：
select * from DSGB_comment where ID IN (select ID from (select rownum as numrow,ID from DSGB_comment order by TIME desc) where numrow > "+ spage +" and numrow < "+ (ipage * pages) +") order by TIME Desc