员工信息表想要求每个部门工资最高的员工

Question

问题遇到的现象和发生背景

员工信息表想要求每个部门工资最高的员工的id,name,dept,salary

问题相关代码，请勿粘贴截图

create table employee
(
    id     serial primary key,
    name   text,
    dept   text,
    salary money
);

运行结果及报错内容

我的解答思路和尝试过的方法

分组查询？

我想要达到的结果

查询结果正确

Answer 1

如果对您有帮助，希望给予采纳 ~

select l.id, l.name, l.dept, l.salary
from employee as l
         join (select max(salary) as salary, dept
               from employee
               group by dept) as r
              on l.dept = r.dept and l.salary = r.salary