Mysql分组函数/多行处理函数

Mysql分组函数/多行处理函数：输入多行，最终输出一行。count(),sum(),avg(),max(),min()。分组函数必须先进行分组，然后才能用。如果没有对数据分组，整张表默认为一组

1、分组函数使用的注意事项：分组函数自动忽略null，不需要提前对null进行处理

mysql> select sum(salary) as sum from user1;
+-------+
| sum   |
+-------+
| 19000 |
+-------+
1 row in set (0.01 sec)

mysql> select count(salary) as count from user1;
+-------+
| count |
+-------+
|     1 |
+-------+
1 row in set (0.00 sec)

2、分组函数中count(*)和count(具体字段)的区别：count(*)不忽略null，count(具体字段)忽略null

mysql> select count(*) from user1;
+----------+
| count(*) |
+----------+
|        4 |
+----------+
1 row in set (0.00 sec)

mysql> select count(salary) from user1;
+---------------+
| count(salary) |
+---------------+
|             1 |
+---------------+
1 row in set (0.00 sec)

3、分组函数不能直接使