请统计每个部门最高工资的员工信息及工资
时间: 2023-11-11 18:15:20 浏览: 43
您可以使用以下 SQL 语句来统计每个部门最高工资的员工信息及工资:
```
SELECT d.department_name, e.first_name, e.last_name, e.salary
FROM employees e
INNER JOIN (
SELECT department_id, MAX(salary) AS max_salary
FROM employees
GROUP BY department_id
) AS max_salaries ON e.department_id = max_salaries.department_id AND e.salary = max_salaries.max_salary
INNER JOIN departments d ON e.department_id = d.department_id;
```
该语句将从 "employees" 表中获取每个部门最高工资的员工信息,并与 "departments" 表进行联接,以获取部门名称。首先,使用嵌套查询找到每个部门的最高工资。然后,将 "employees" 表与这些最高工资进行联接,以查找具有最高工资的员工信息。最后,将结果与 "departments" 表进行联接,以获取部门名称。