具有多个值的 CASE IN 语句 [英] CASE IN statement with multiple values
本文介绍了具有多个值的 CASE IN 语句的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
有没有办法用 IN 子句制作 CASE 语句?
Is there a way to make a CASE statement with an IN clause?
SELECT
CASE c.Number
IN ('1121231','31242323') THEN 1
IN ('234523','2342423') THEN 2
END AS Test
FROM tblClient c
推荐答案
是的.您需要使用<的搜索"形式而不是简单"形式code>CASE 表达式
Yes. You need to use the "Searched" form rather than the "Simple" form of the CASE
expression
SELECT CASE
WHEN c.Number IN ( '1121231', '31242323' ) THEN 1
WHEN c.Number IN ( '234523', '2342423' ) THEN 2
END AS Test
FROM tblClient c
这篇关于具有多个值的 CASE IN 语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文