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; |