SELECT COUNT(1) AS 总数,
COUNT(CASE WHEN 条件 THEN 1 ELSE NULL END) AS 别名1,
COUNT(CASE WHEN 条件 THEN 1 ELSE NULL END) AS 别名2
FROM 表名
01-14
1740
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
SELECT COUNT(1) AS 总数,
COUNT(CASE WHEN 条件 THEN 1 ELSE NULL END) AS 别名1,
COUNT(CASE WHEN 条件 THEN 1 ELSE NULL END) AS 别名2
FROM 表名