数据库-聚合函数-max函数

avg函数

mysql> select avg(price) from shop;
+‐‐‐‐‐‐‐‐‐‐‐‐+
| avg(price) |
+‐‐‐‐‐‐‐‐‐‐‐‐+
| 6.110000 |
+‐‐‐‐‐‐‐‐‐‐‐‐+

max函数

语法：select max(列名) from 表名;

mysql> select max(price) from shop;
+‐‐‐‐‐‐‐‐‐‐‐‐+
| max(price) |
+‐‐‐‐‐‐‐‐‐‐‐‐+
| 19.95 |
+‐‐‐‐‐‐‐‐‐‐‐‐+

min函数

语法：select min(列名) from 表名;

mysql> select min(price) from shop;
+‐‐‐‐‐‐‐‐‐‐‐‐+
| min(price) |
+‐‐‐‐‐‐‐‐‐‐‐‐+
| 1.25 |
+‐‐‐‐‐‐‐‐‐‐‐‐+