求问一个sql server 排序order by 的问题

[huangkai277]

一个表有10000条数据，两个字段 number ，time

我想从这个表先按time时间字段从大到小排序取出3000条数据，然后再按number号码字段从小到大排序。。这个语句要怎么写？

这条语句没用，查出来只是按时间从大到小排序的， 号码没有从小到大
select top 3000 number,time from table order by time desc,number asc

[三流角色]

select * from (select top 3000 number,time from table order by time desc) t order by t.number asc

[xiaoxiangqing]

select * from (select top 3000 number,time from table order by time desc) a order by number asc

[唐诗三百首]

-- 创建临时表用于保存结果
select number,[time]
 into #result
 from [表名]
 where 1=2

-- 先按time时间字段从大到小排序取出3000条数据
insert into #result(number,[time])
select top 3000 number,[time]
 from [表名]
 order by [time] desc
 
-- 然后再按number号码字段从小到大排序
insert into #result(number,[time])
 select number,[time]
 from [表名] a
 where not exists(select 1 
                              from #result b 
							  where b.number=a.number and b.[time]=a.[time])
 order by a.number

-- 查看结果
select * from #result