具有多个值的CASE IN语句

admin

具有多个值的CASE IN语句

sql

有没有一种方法可以使用IN子句进行CASE语句？

SELECT
CASE c.Number
IN ('1121231','31242323') THEN 1
IN ('234523','2342423') THEN 2
END AS Test
FROM tblClient c

阅读 165

2021-05-10

共1个答案

admin

是的。您需要使用CASE表达式的“搜索”形式而不是“简单”形式

SELECT CASE
         WHEN c.Number IN ( '1121231', '31242323' ) THEN 1
         WHEN c.Number IN ( '234523', '2342423' ) THEN 2
       END AS Test
FROM   tblClient c

2021-05-10