mysql基础---分组函数介绍

#二、分组函数
/*
功能：用作统计使用，又称为聚合函数或统计函数或组函数
分类:
sum求和、avg平均值、max最大值、min最小值、count统计个数
*/
#1.简单的使用
SELECT SUM(salary) FROM  employees;
SELECT AVG(salary) FROM  employees;
SELECT MIN(salary) FROM  employees;
SELECT MAX(salary) FROM  employees;
SELECT COUNT(salary) FROM  employees;
SELECT SUM(salary) 和,AVG(salary) 平均值,MIN(salary) 最小值,MAX(salary) 最大值,COUNT(salary)
出现次数 FROM  employees;
SELECT SUM(salary) 和,ROUND(AVG(salary),2) 平均值,MIN(salary) 最小值,MAX(salary) 最大值,COUNT(salary)
出现次数 FROM  employees;

#2.参数支持哪些类型
//前两种没有意义，第一个写法是错误的
SELECT SUM(last_name),AVG(last_name) FROM employees;
SELECT SUM(hiredate),AVG(hiredate) FROM employees;

SELECT MIN(last_name),MAX(last_name) FROM employees;
SELECT MAX(hiredate),MIN(hiredate) FROM employees;

SELECT COUNT(commission_pct) FROM employees;
SELECT COUNT(last_name) FROM employees;

#3.是否忽略null值
SELECT SUM(commission_pct),AVG(commission_pct),SUM(commission_pct)/35,SUM(commission_pct)/107
FROM  employees;
SELECT COUNT(commission_pct) FROM  employees;
SELECT MAX(commission_pct),MIN(commission_pct) FROM  employees;

分类：sum求和、avg求平均值、max求最大值、min最小值、count计算个数
特点：1.sum、avg一般用于处理数值型
2.以上分组函数都忽略null值