&6、聚合函数
一、聚合函数的使用
1、聚合函数:SQL官方提供的一个用来常见运算的一个函数
1.count(*|列名)统计行数
mysql> select count(*) from t_user;
+----------+
| count(*) |
+----------+
| 4 |
+----------+
mysql> select count(idd) from t_user;
+------------+
| count(idd) |
+------------+
| 4 |
+------------+
1 row in set (0.00 sec)
2.min(列名)——最小值 max(列名)——最大值
mysql> select min(age) from t_user;
+----------+
| min(age) |
+----------+
| 8 |
+----------+
m
mysql> select max(age) from t_user;
+----------+
| max(age) |
+----------+
| 23 |
+----------+
3.sum(数值类型列名)——求和
mysql> select sum(age) from t_user;
+----------+
| sum(age) |
+----------+
| 74 |
+----------+
4.avg(数值类型列名)——平均数
mysql> select avg(age) from t_user;
+----------+
| avg(age) |
+----------+
| 18.5000 |
+----------+