SELECT e.department_id, s.employee_id, s.salary
FROM salary s
JOIN employees e ON s.employee_id = e.employee_id
WHERE s.salary = (
SELECT MAX(salary)
FROM salary s2
JOIN employees e2 ON s2.employee_id = e2.employee_id
WHERE e2.department_id = e.department_id
)
ORDER BY e.department_id; 看懂了这个，感觉sql水平上了一个台阶
FROM salary s
JOIN employees e ON s.employee_id = e.employee_id
WHERE s.salary = (
SELECT MAX(salary)
FROM salary s2
JOIN employees e2 ON s2.employee_id = e2.employee_id
WHERE e2.department_id = e.department_id
)
ORDER BY e.department_id; 看懂了这个，感觉sql水平上了一个台阶
展开
1
1