[MySQL] 同じカラム合計複数条件別々

1 min read
hiroweb developer
SELECT SUM(CASE WHEN Jouhou = 'A' THEN 1 ELSE 0 END)as 'A',
       SUM(CASE WHEN Jouhou = 'B' THEN 1 ELSE 0 END)as 'B',
       SUM(CASE WHEN Jouhou IS NULL THEN 1 ELSE 0 END)as 'null'
FROM   DBTable