MySQL分组函数的使用特点

参数支持类型

1. sum、avg 只支持数值型
2. max、min、count 支持所有类型

# 不支持以下类型，不合法
SELECT SUM(last_name), AVG(last_name) FROM employees;
# max和min支持字符型和日期型
SELECT MAX(last_name), MIN(last_name), MIN(hiredate) FROM employees;
# count 支持所有
SELECT COUNT(commission_pct), COUNT(last_name) FROM employees;

忽略 null

这些分组函数都忽略null值：

SELECT SUM(commission_pct), AVG(commission_pct), SUM(commission_pct)/35,SUM(commission_pct)/107 FROM employees;
SELECT MAX(commission_pct),MIN(commission_pct) FROM employees;