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

　　

posted @ 2019-09-05 17:41  Hi！宋先生  阅读(3584)  评论(0)  编辑  收藏  举报