sql - 查询显示各部门工资最低的员工

Question

我想根据salary显示每个部门收入最低的员工使用 min() .
我有员工表 id, first name, last name, department id, salary和部门，department_id, name部门编号从 1 到 5。
我在做这件事时遇到了麻烦，我只知道如何开始SELECT name, surname from employees WHERE...

Answer 1

您将使用 min()为了这。您将使用窗口函数:

select e.*
from (select e.*,
             rank() over (partition by department_id order by salary) as seqnum
      from employees e
     ) e
where seqnum = 1
order by department_id;