sql 常用统计函数

（1）一列中不同值的数据量统计

1.使用count   

count(channel = 0 OR NULL) AS '注册', 

count(channel = 1 OR NULL) AS '新增',

2.使用sum+if 

sum(IF(channel = 0, 1, 0)) AS '注册',

sum(IF(channel = 1, 1, 0)) AS '新增',

3.使用sum 

sum(channel = 0) AS '注册',

sum(channel = 1) AS '新增',

4.使用count+group by 

channel,count(*) num FROM users  GROUP BY channel;

5.使用sum+case when

SUM(CASE WHEN channel = 0 THEN 1 END) AS '注册',

SUM(CASE WHEN channel = 1 THEN 1 END) AS '新增'

6.使用count+case when

count(CASE WHEN channel = 0 THEN 1 END) AS '注册',

count(CASE WHEN channel = 1 THEN 1 END) AS '新增',

原链接：​​​​​​MySQL统计一列中不同值（字段的不同值）的数量的六种方式及其结果和耗时的比较_xiangwangxiangwang的博客-CSDN博客