mysql分组函数（聚合函数）

sum

SELECT SUM(id) FROM student

avg

SELECT AVG(salary) FROM student

max

SELECT MAX(id) FROM student

min

SELECT MIN(id) FROM student

count

SELECT COUNT(id) FROM student

这几个函数都 可以搭配distinct使用

```sql
SELECT COUNT(DISTINCT id) FROM student

用来统计行数

SELECT COUNT(*) FROM student

如果是myisam引擎的话 count(）的效率高
如果是innodb的话 count(）和count(1）效率差不多，比count(字段)高一些