sql 查询多个条件的多个数量

最新推荐文章于 2026-04-18 03:03:28 发布

原创最新推荐文章于 2026-04-18 03:03:28 发布 · 4.4k 阅读

6 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sql #mybatis #java #spring boot

收录于

java知识积累专栏收录该内容

59 篇文章

订阅专栏

本文通过SQL查询，汇总了s_equipment表中各设备状态（1-5）的数量，分别展示了总数量及各状态（闲置、使用、测试、正常、待命）的分布，提供了设备活跃度洞察。

SELECT
            COUNT(*) AS total,
            COUNT(case when device_state = '1' then device_state else null end) as totalBeiyong,
            COUNT(case when device_state = '2' then device_state else null end) as totalTingyong,
            COUNT(case when device_state = '3' then device_state else null end) as totalTingji,
            COUNT(case when device_state = '4' then device_state else null end) as totalZhengchang,
            COUNT(case when device_state = '5' then device_state else null end) as totalDaibing
        FROM
            s_equipment