排序問題，請高人指教！

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

這個(gè)按時(shí)間排序不行，該怎么寫��？謝謝！

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

肯定可以，我找人驗(yàn)證過了

77woshi

這樣做的只是先分頁后排序的，我要的結(jié)果是在先排序后分頁

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

子查詢是不能排序的