SELECT
batNo,
COUNT(id) AS count, #统计总数
SUM(case when abnomal = 2 then 1 else 0 end) as excCount, #统计abnomal=2(异常)的总数
SUM(matTheWei) AS sumMatTheWei, #求和
SUM(matPraWei) AS sumMatPraWei,
AVG(case when abnomal <> 2 then negativeRate else 0 end) AS countNegativeRate, #统计 abnomal!= 2(正常)的平均数
AVG(negativeRate) AS avgNegativeRate, #统计所有平均数
MIN(rollingDate) AS minRollingDate, #最小值
classCode
FROM
sys_plan_bet
WHERE 1=1
GROUP BY batNo
ORDER BY batNo desc
mysql 分组统计
最新推荐文章于 2024-08-24 04:06:00 发布