sql when

来源：百度知道 编辑：UC知道 时间：2024/05/29 11:31:47
sum(CASE [问题9] WHEN '%1%' THEN 1 ELSE 0 END),
sum(CASE [问题9] WHEN '%2%' THEN 1 ELSE 0 END),
sum(CASE [问题9] WHEN '%3%' THEN 1 ELSE 0 END),
sum(CASE [问题9] WHEN '%4%' THEN 1 ELSE 0 END),
sum(CASE [问题9] WHEN '%5%' THEN 1 ELSE 0 END),
sum(CASE [问题9] WHEN '%6%' THEN 1 ELSE 0 END),
sum(CASE [问题9] WHEN '%7%' THEN 1 ELSE 0 END),
sum(CASE [问题9] WHEN '%8%' THEN 1 ELSE 0 END),

实现：问题9包含“1” 就计数1次
为什么这句话不行啊 还是有其他的写法 谢谢各位大侠

[问题9]--位置改一下加上like
sum(CASE WHEN [问题9] like '%1%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] like'%2%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] like'%3%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] like'%4%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] like'%5%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] like'%6%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] like'%7%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] like'%8%' THEN 1 ELSE 0 END),

sum(CASE WHEN [问题9] LIKE '%1%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] LIKE '%2%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] LIKE '%3%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] LIKE '%4%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] LIKE '%5%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] LIKE '%6%' THEN 1 ELSE 0 END),
sum(CASE WHEN [问题9] LIKE '%7%' THEN 1 ELSE 0 END),
sum(