本文主要是介绍mysql 错题集，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

1.查询各部门中工资比本部门平均工资高的员工的员工号,姓名和工资

①查询各部门的平均工资

SELECT AVG(salary),department_id
FROM employees
GROUP BY department_id;

②连接①结果集和employees表,进行筛选

SELECT employee_id,last_name,salary,e.department_id
FROM employees e
INNER JOIN (
	SELECT AVG(salary) ag ,department_id
	FROM employees
	GROUP BY department_id
)ag_dep
ON e.`department_id` = ag_dep.department_id
WHERE salary > ag;

这篇关于mysql 错题集的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！