题目如下:
题解如下:
SELECT
d.NAME Department,
e.NAME Employee,
e.salary
FROM
employee e,
department d
WHERE
e.DepartmentId = d.id
AND ( e.salary, e.DepartmentId ) IN ( SELECT max( salary ), DepartmentId FROM Employee GROUP BY DepartmentId )
题目如下:
题解如下:
SELECT
d.NAME Department,
e.NAME Employee,
e.salary
FROM
employee e,
department d
WHERE
e.DepartmentId = d.id
AND ( e.salary, e.DepartmentId ) IN ( SELECT max( salary ), DepartmentId FROM Employee GROUP BY DepartmentId )