怎么按照指定次序对结果集进行排序.

[wd_6532]

比如 有记录

1
0
3
7
5

我想把1排在3排在最前面,然后其他的倒序排列

怎么实现.

[chuifengde]

select * from [Table] order case [Field] when 1 then 0 when 3 then 1 else 2 end,[Field] desc

[wgzaaa]

把1排在3排在最前面－－－什么意思　　

[wd_6532]

哈哈,打错了.

把1排在最前面,其他的到排序.

1楼答案应该是正确的,谢谢.

[wgzaaa]

select *,(1-a)*(1+a) from #1 order by (case when a=1 then 99999 else a end) desc

[wd_6532]

楼上语句是什么意思

[octwind]

select * from tb where id=1 union all
select * from tb where id=3 union all
select * from tb t where not exists (select 1 from tb where id=t.id and (id=1 or id=3)) order by id desc

[utpcb]

选择判断的意思