Mysql 根据某字段分类查询各类数量

最新推荐文章于 2023-02-15 10:42:32 发布

安静的博客

最新推荐文章于 2023-02-15 10:42:32 发布

阅读量2.4k

点赞数 3

分类专栏：数据库文章标签： mysql

本文链接：https://blog.csdn.net/Mario1169/article/details/106279119

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1、统计总数量以及某字段分类数量

SELECT
COUNT( CASE WHEN p.run_status = 0 THEN 1 END ) AS tjsp,
COUNT( CASE WHEN p.run_status = 1 THEN 1 END ) AS cdsp,
COUNT( CASE WHEN p.run_status = 2 THEN 1 END ) AS fdsp,
COUNT( CASE WHEN p.run_status = 3 THEN 1 END ) AS djsp,
COUNT( CASE WHEN p.run_status = 4 THEN 1 END ) AS bjsp,
COUNT( CASE WHEN p.run_status = 5 THEN 1 END ) AS gzsp,
COUNT( CASE WHEN ( p.run_status = 6 OR p.run_status IS NULL ) THEN 1 END ) AS lxsp,
COUNT( 1 ) AS totalp
FROM
da_energy_station_pcs p