一条SQL返回多个统计求和使用:
select
SUM(CASE WHEN XXXX='xxxx' THEN 1 ELSE 0 END) AS 'xxxx'
SUM(CASE WHEN XXXX='xxxx' THEN 1 ELSE 0 END) AS 'xxxx'
SUM(CASE WHEN XXXX='xxxx' THEN 1 ELSE 0 END) AS 'xxxx'
SUM(CASE WHEN XXXX='xxxx' THEN 1 ELSE 0 END) AS 'xxxx'
from xxxx
求和为0不返回null而是返回0则要使用:
COALESCE(SUM(CASE WHEN XXXX='xxxx' THEN 1 ELSE 0 END),0) AS 'xxxx',