zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

sql 聚合语句,count的用法「建议收藏」

SQL 建议 收藏 语句 用法 聚合 count
2023-06-13 09:12:01 时间

大家好,又见面了,我是你们的朋友全栈君。

如要获取 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://javaforall.cn/155235.html原文链接:https://javaforall.cn