MySQL 分组查询

分组查询

语法

SELECT 查询函数,分组
FROM 表名
GROUP BY 分组名;

样例

//查询每个工种的工资最大值
SELECT MAX(salary),job_id
FROM employees
GROUP BY job_id;

包含筛选条件

//查询邮箱中包含a字符的，每个部门的平均工资
SELECT AVG(salary),department_id
FROM employees
WHERE email LIKE '%a%'
GROUP BY department_id;

对分组后结果筛选

//查询部门员工大于2的部门
SELECT COUNT(*),department_id
FROM employees
GROUP BY department_id
HAVING COUNT(*) > 2;