select * from X表 order by B,(case D when '004' then 1 else 2 end),D
NND,你真利害,你是我偶像.太强了.分都给你.真是好人!!!!!!
Select * from X Order By B,(Case D When '004' Then 0 Else 1 End),D------------------------ 结果A B C D 9 mm xdf 004 2 mm dd 001 4 mm tt 006 7 xx kk 004 6 xx yy 001 3 xx vv 005
*
from
X表
order by
B,(case D when '004' then 1 else 2 end),D
结果A B C D
9 mm xdf 004
2 mm dd 001
4 mm tt 006
7 xx kk 004
6 xx yy 001
3 xx vv 005