Using "Case When [then]" in [Order by] can make it success
Example:
Example:
SELECT * FROM [TableName] where [Column] in ('A','B','C','D')
Order by CASE [Column]
WHEN 'A' THEN 1
WHEN 'B' THEN 2
WHEN 'C' THEN 3
WHEN 'D' THEN 4
end
留言