排序问题，请高人指教！

77woshi

select * from (select sms_interface_bak.*,rownum num from sms_interface_bak where to_char(sys_time,'yyyy-mm-dd') between '2006-05-28' and '2006-06-15' and rownum<=18 order by sys_time desc) where num>=0

这个按时间排序不行，该怎么写啊？谢谢！

77woshi

难道没人知道吗？

wq_1228

把order by　放在外边试一下。

77woshi

不行

wq_1228

select * from
(select A.*,rownum num
from A
where to_char(a,'yyyy-mm-dd')
between '2006-01-28' and '2006-06-15'
and rownum<=18 )
where num>=0 order by a desc

肯定可以，我找人验证过了

77woshi

这样做的只是先分页后排序的，我要的结果是在先排序后分页

jametong

需要再加一层子查询的..

select * from (
   select * from (
      select * from table where .. order by col
   )
   where rownum <= 18
)
where num >= 0

doni

select * from (
      select * from table where .. order by col
   )
   where rownum <= 18
这样就可以了
where num>=0没有意义

chris0820

子查询是不能排序的