sql 聚合语句,count的用法

2018/07/10 16:20
阅读数 3
如要获取 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

 

展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部