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
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
转载于:https://www.cnblogs.com/Angel-szl/p/11468602.html