sql 聚合语句，count的用法

如要获取 result = '1' 的数量
COUNT(
　　CASE
　　WHEN result = '1' THEN
　　result
　　END
)

 

SELECT
　　*
FROM
(
SELECT
batchNo,
serviceId,
result,
projectId,
sum(passCount) AS passCount,
COUNT(
CASE
WHEN result = '1' THEN
result
END
) AS quality,
COUNT(
CASE
WHEN (result = '2' OR result = '0') THEN
result
END
) AS type,
COUNT(
CASE
WHEN result = '2' THEN
result
END
) AS qualityTime,
COUNT(
CASE
WHEN result = '0' THEN
result
END
) AS qualityName,
COUNT(questionId) AS questionId,
sum(auditCount) AS auditCount,
auditTime,
id,
serviceName
FROM
picture_audit_helper
WHERE
1 = 1
GROUP BY
serviceName,
DATE_FORMAT(auditTime, '%Y-%m-%d')
) AS t
GROUP BY
auditTime DESC
LIMIT 1

 

转载于:https://www.cnblogs.com/lemon-flm/p/9289753.html