Mysql学习——聚合函数

# sum: 求和，自动忽略NULL
SELECT SUM(salary)
FROM employees;

# avg：求平均值，自动忽略NULL
SELECT AVG(salary)
FROM employees;

# min: 最小值，自动忽略NULL
SELECT MIN(salary)
FROM employees;

# max: 最大值，自动忽略NULL
SELECT MAX(salary)
FROM employees;

# count: 计算非空值个数
# tips: 如果count里面跟的是字段名，会自动忽略NULL
# 	如果count里面是*或0，1，2等常量只要不是NULL，就会返回所有行数
#	如果count里面是NULL，那么会返回0
#	常配合distinct 去重，计算有多少不一样的值
SELECT COUNT(commission_pct)
FROM employees; 
SELECT COUNT(*)
FROM employees; 
SELECT COUNT(0)
FROM employees; 
SELECT COUNT(NULL)
FROM employees; 
SELECT COUNT(DISTINCT commission_pct)
FROM employees; 

# 和分组函数一同查询的字段不能这样用
SELECT AVG(employee_id),salary 
FROM employees;