Question

SQL怎样把查出来的结果集再倒序查询？

有一张表tableID:
s_id
1
2
3
4
5
6
7
8
9
10
现在想得到5 4 3 2 1这样的结果集.
用select top 5 s_id from tableID order by s_id desc得到的结果是10 9 8 7 6
用select top 5 s_id from (select top 5 s_id from tableID) as T order by s_id desc得到的结果集还是10 9 8 7 6
如果用in子查询很简单，但是题目要求不能用！有高手能指教下不？
同时不能用> <号

Answer 1

if object_id('tb') > 0 drop table tb
go
create table tb (sid int)
insert into tb select '1'
union all select '2'
union all select '3'
union all select '4'
union all select '5'
union all select '6'
union all select '7'
union all select '8'
union all select '9'
union all select '10'

select * from (select top 5 * from tb) t
order by t.sid desc

楼主直接给分吧、哈哈！

Answer 2

select T.s_id from (select top 5 s_id from tableID order by s_id ) as T order by T.s_id desc

Answer 3

select * from (select top 5 s_id from tableID order by s_id ) aa order by s_id desc

Answer 4

Order by ...