MySQL聚合函数查询

1、 COUNT() 函数

COUNT(*) 函数统计数据表中包含的记录行的总数；COUNT(字段名称) 计算该字段的总行数量、忽略空值的行。

mysql> select count(*) as cust_num
    -> from tb_2;

mysql> select count(name) as name_num
    -> from tb_2;

2、 SUM函数

mysql> select sum(price) as price_sum
    -> from tb_2;

3、AVG() 函数

mysql> select avg(price) as price_avg
    -> from tb_2;

4、 MAX() 函数 求该列中最大的值

mysql> select max(price) as max_price
    -> from tb_2;

求该列最小的值

mysql> select min(price) as min_price
    -> from tb_2;