Sql排序问题

Question

求一条Sql语句
表Testid       OnTop          CreateDate
1          11        2008-01-11 02:02:00.000
2          3         2008-01-14 02:02:00.000
3          3        2008-01-17 02:02:00.000
4          1         2008-01-13 02:02:00.000
5          3         2008-01-16 02:02:00.000
6          3         2008-01-9 02:02:00.000
7          9         2008-01-7 02:02:00.000
8          3        2008-01-12 02:02:00.000
9          4         2008-01-1 02:02:00.000
现在需要的结果是
id       OnTop          CreateDate
1          11        2008-01-11 02:02:00.000
7          9         2008-01-7 02:02:00.000
9          4         2008-01-1 02:02:00.000
4          3         2008-01-17 02:02:00.000
5          3         2008-01-16 02:02:00.000
6          3         2008-01-14 02:02:00.000
7          3         2008-01-12 02:02:00.000
8          3         2008-01-9 02:02:00.000
9          1         2008-01-13 02:02:00.000
所要的结果就是先根据字段OnTop排序,当OnTop的值相同的时候根据CreateDate字段排序

Answer 1

select *
from t
order by OnTop desc,createDate desc

Answer 2

select * from Test
order by OnTop, CreateDate

Answer 3

select id,OnTop,CreateDate from table1 order by Ontop desc,CreateDate desc

Answer 4

select * from Test
order by OnTop desc, CreateDate desc

Answer 5

SELECT * FROM Test ORDER BY OnTop DESC,CreateDate DESC
抢分啊

Answer 6

select * from Test
order by OnTop desc, CreateDate desc呵呵

Answer 7

select *
from test
order by OnTop desc,createDate desc楼主给分吧

Answer 8

select *
from t
order by OnTop desc,createDate desc

Answer 9

select * from Test
order by OnTop desc, CreateDate desc

Answer 10

select * from test order by OnTop desc, CreateDate desc

Answer 11

select * from test order by OnTop desc, CreateDate desc
速度慢了

Answer 12

select   id,OnTop,CreateDate   from   table1   order   by   Ontop   desc,CreateDate   desc

Answer 13

select * from test order by Ontop DESC,CreateDate DESC