mysql 一句sql实现各个分类的统计:
创建测试表,表结构如下:
SELECT
COUNT(1),
SUM(CASE WHEN check_steps = 0 THEN 1 ELSE 0 END) 1Count,
SUM(CASE WHEN check_steps = 1 THEN 1 ELSE 0 END) 2Count,
SUM(CASE WHEN check_steps = 2 THEN 1 ELSE 0 END) 3Count,
SUM(CASE WHEN check_steps = 3 THEN 1 ELSE 0 END) 4Count
FROM
check_contribution_records WHERE check_status = 0;
可一次性得到:
不用写多个查询语句就能解决问题。
标签:CASE,END,SUM,mysql,WHEN,ELSE,---,sql,check
来源: https://www.cnblogs.com/wujf-myblog/p/14520324.html