牛客网刷题之SQL-12.获取所有部门中当前员工薪水最高的相关信息

获取所有部门中当前员工薪水最高的相关信息

目录

1. 题目

2. 解题

---

题目链接

1. 题目

2. 解题

SELECT
    a.dept_no AS dept_no,
    a.emp_no AS emp_no,
    MAX(b.salary) AS salary
FROM
    dept_emp a JOIN salaries b
    ON a.emp_no = b.emp_no
    AND a.to_date = '9999-01-01' AND b.to_date='9999-01-01'
GROUP BY
    a.dept_no
ORDER BY
    a.dept_no ASC;