SQL方面的建议哈
SELECT SYXM, COUNT(*) as 合格数量 FROM 表名 WHERE PDJG = '合格' GROUP BY SYXM
这个是子查询
下面这样写
SELECT BBRQ, SYXM, PDJG, CASE WHEN SYXM = 'cass' THEN
(SELECT COUNT(*) FROM 表名 WHERE SYXM = 'cass' AND PDJG = '合格') WHEN SYXM = '中性' THEN (SELECT COUNT(*) FROM 表名 WHERE SYXM = '中性' AND PDJG = '合格') WHEN SYXM = '耐湿' THEN (SELECT COUNT(*) FROM 表名 WHERE SYXM = '耐湿' AND PDJG = '合格') WHEN SYXM = '其他' THEN (SELECT COUNT(*) FROM 表名 WHERE SYXM = '其他' AND PDJG = '合格') ELSE NULL END as 合格数量 FROM 表名