【SQL】第9章 汇总查询得到的数据

9.1 聚合函数

9.1.1 COUNT函数

语法说明	使用场景
计数函数(统计表中的记录数量） 1.count(column name); 2.count(distinct column name); 3.Count (all column name); 4.Count(*);	1.Select count(employeeid) from employees; 2.select count(distinct salary) from employees; 3.select count (all salary) from employees; 4.select count (*) from employees;

9.1.2 SUM函数

语法说明	使用场景
1.Sum(column name) 2.Sum(distinct coulumn name)	1.Select sum (salary)from employees; 2.select sum(distinct cost) from employees; 说明：使用distinct它返回不重复的记录

9.1.3 AVG函数

语法说明	使用场景
1.Avg(column name) 2.Avg(distinct column name)	1.select avg (salary)from employees; 2.select avg (distinct salary) from employees; 说明：求平均数必须是数值型

9.1.4 MAX函数

语法说明	使用场景
1.max(column name) 2.Max(distinct column name)	1.select max (salary) from employees; 2.select max (distinct salary) from employees;

9.1.5 MIN函数

语法说明	使用场景
1.min(column name) 2.Min(distinct clumn name)	1.select min (salary) from employees; 2.Select min (distinct salary)from employees;

9.2 小结

9.3 问与答

9.4 实践

9.4.1 检测

9.4.2 练习