mysql学习day6

分组函数

功能：用作统计使用，又称为聚合函数或统计函数或组函数
分类：求和sum、avg平均、max最大值、min、count计算个数
1.简单使用

select sum (salary) from employees;
select avg (salary) from employees;
select max (salary) from employees;
select min(salary) from employees;
select count (salary) from employees;

select sum (salary) 和,avg (salary) 平均,max (salary) 最高 from employees;
select sum (salary) 和,round(avg (salary),2) 平均,max (salary) 最高 from employees;

2参数支持哪些类型

select sum(last_name),avg(last_name) from employees;#不支持，不报错，不对
#sum、avg认为只支持数值型
select max(last_name),min(last_name) from employees;
#max、min支持字符、日期、数值、任何
select count (last_name) from employees;
#count都支持，返回不为null的个数
#3.null是否参与运算
#sum、avg、max、min运算忽略null值
#count，计算非空值的个数，忽略null
#以上的分组函数忽略null值

#4、和distinct搭配,实现去重的运算

select sum(distinct salary),sum(salary) from employees;
select count(distinct salary),count(salary) from employees;