mysql - 修复 mysql 中的查询

Question

我需要在 School 表中显示任何部门总工资最高的部门代码。

所以我尝试了这个:

SELECT MAX(Total), dept 

FROM (SELECT SUM(salary) AS Total, dept from school group by dept) AS Temp;

这给了我正确的结果；但是它显示了 MAX(Total) 字段，我只想显示部门的代码。我应该改变什么？

Answer 1

你可以做到

SELECT a.dept FROM (
    SELECT MAX(Total), dept 

    FROM (SELECT SUM(salary) AS Total, dept from school group by dept) AS Temp
) AS a;