Sql查询按某字段值排序

SELECT * FROM dbo.check_groups
 ORDER BY CASE   WHEN  GroupCode=‘DR02‘ THEN 3
 WHEN GroupCode= ‘DR03‘ THEN 2 WHEN GroupCode= ‘DR01‘ THEN	1 ELSE 0 END DESC

Sql查询按某字段值排序

标签：order   sele   highlight   排序   order by   select   cas   case   groups