SELECT max(salary), dept
FROM Employees
GROUP BY dept;
如何添加fname和lname而不出现错误?如果我把他们加在一起,我就再也拿不到最高工资了。
这就是我在SQL Server中的操作方式。。。您需要一个子查询来返回每个部门的最高工资,然后将其返回到员工表中,以确定哪个员工拥有该部门的工资:
SELECT D.Dept, D.MaxSalary, Employees.FName, Employees.LName
FROM (
SELECT MAX(Salary) AS MaxSalary, Dept
FROM Employees
GROUP BY dept
) D
INNER JOIN Employees
ON Employees.Dept = D.Dept
AND Employees.Salary = D.MaxSalary