sql语句如何 按指定的某列的摸个值排序

[wftznexwn]

如题：

select * from dbo.Archives_CM where cmcode='3707850101000009' order by HumanCode='03'
按HumanCode='03'的那一列排序

[水族杰纶]

HumanCode='03' 值是什么？

[wftznexwn]

HumanCode='03' 这一行

[wftznexwn]

把这个放在首位

[hyrongg]

如果HumanCode 固定只有那么几个，可以用Case

select * from dbo.Archives_CM where cmcode='3707850101000009'  
order by case when HumanCode='03' then 1
                   else 2 end asc

[MrYangkang]

HumanCode='03' 排序 首先 HumanCode<>'03' 的数据要不要，如果要,只能这样写 select * from dbo.Archives_CM where cmcode='3707850101000009' order by HumanCode desc[asc] 如果不要,那就这样写 select * from dbo.Archives_CM where cmcode='3707850101000009' and HumanCode='03' order by HumanCode desc[asc] 也就是说，不能按照某列的值排序，只能按照表中的某列排序，而不是值

[dengixnyu]

select * from dbo.Archives_CM where cmcode='3707850101000009' and HumanCode='03' union all select * from dbo.Archives_CM where cmcode='3707850101000009' and HumanCode=<>'03'

[dengixnyu]

select * from dbo.Archives_CM where cmcode='3707850101000009' and HumanCode='03' union all select * from dbo.Archives_CM where cmcode='3707850101000009' and HumanCode<>'03' --上面不小心多了个符号。