SELECT
bg_responsible
SUM( CASE WHEN BG_SEVERITY = '1-低' THEN 1 ELSE 0 END ) AS 低的数量,
SUM( CASE WHEN BG_SEVERITY = '2-中' THEN 1 ELSE 0 END ) AS 中的数量,
SUM( CASE WHEN BG_SEVERITY = '3-高' THEN 1 ELSE 0 END ) AS 高的数量
FROM
表
GROUP BY
bg_responsible
追问Incorrect syntax near the keyword 'CASE'.
为什么case会出错
追答你什么数据库?
Access ?
追问SQL server
追答SELECT
bg_responsible , ( 这里少了个逗号)