两个条件分组统计sql

最新推荐文章于 2022-12-08 11:46:58 发布

五木子

最新推荐文章于 2022-12-08 11:46:58 发布

阅读量4.5k

点赞数 1

本文链接：https://blog.csdn.net/llljyb/article/details/78362308

版权

applyInfo：
SELECT
   SUM(
       IF (
           a.certificate_level_id = 'ZSLX001',
           1,
           0
       )
   ) AS typeA,
   SUM(

       IF (
           a.certificate_level_id = 'ZSLX002',
           1,
           0
       )
   ) AS typeB,
   SUM(

       IF (
           a.certificate_level_id = 'ZSLX003',
           1,
           0
       )
   ) AS typeC,
   COUNT(*) AS total,
   i.organization_name AS organizationName
FROM
   applyinfo a
LEFT JOIN identifyorganization i ON a.identifyOrganizationId = i.id
WHERE
   a.current_node = 999
AND a.`status` = 1
GROUP BY
   a.identifyOrganizationId