mysql 查询总数，成功数，失败数，调用成功率，根据某条件分组

最新推荐文章于 2024-07-17 15:10:23 发布

轻松和愉快

最新推荐文章于 2024-07-17 15:10:23 发布

阅读量3k

点赞数 4

分类专栏： java-后端

本文链接：https://blog.csdn.net/weixin_48414266/article/details/118637894

版权

mysql

java-后端专栏收录该内容

6 篇文章

订阅专栏

在这里插入图片描述
SELECT
a.south_system_id as southSystemId,
b.description as southSystemName,
COUNT(0) AS total,
SUM(IF(a.invoke_status = 1,1,0)) AS succeedCount,
SUM(IF(a.invoke_status = 0,1,0)) AS failCount,
CONCAT(FORMAT(SUM(IF(a.invoke_status = 1,1,0))/ COUNT(0)*100, 2), ‘%’) AS successRate
FROM
res_invoke_south_system_log as a
left join
res_south_system as b
on a.south_system_id = b.south_system_id
GROUP BY
a.south_system_id