SQL 查询返回无效序列

Question

您好，我正在使用带 IN 运算符的简单查询。我正在使用以下查询

SELECT CustID  FROM Customer WHERE CustID in (6,34,5,4,3,2,1)

现在显示Following Order

custId  
1   
2   
3   
4   
5   
6   
34

但我希望结果与我在 IN 子句中传递的序列相同。

Answer 1

SELECT CustID  FROM Customer WHERE CustID in (6,34,5,4,3,2,1)
ORDER BY  CASE WHEN CustId = 34
               THEN 5.5
               ELSE CustId
          END DESC