Employee 表包含所有员工信息,每个员工有其对应的 Id, Name,Salary 和 DepartmentId。
+----+-------+--------+---,12星座 公主 礼服 儿童-----------+
| Id | Name | Salary | DepartmentI面试题d |
+----+-------+--------+--sql数据库------------+
| 1 | Joe | 70000 | 1面试题同事不配合工作怎么办 |
| 2 | Henry | 80000 | 2 |
| 3 | Sam | 60000 | 2 |
| 4 | Max | 90000 | 1 |
Department 表包含公司所有部门的信息。
+----+----------+
| Id |苏卿陆容渊免费阅读 Name |
+----+----------+
| 1 | IT |
| 2 | Sales |
+----+----------+
您好,答案如下:
2021-10-04 16:15select Departmentid,Name,Salary,rn
from(select *,
row_number()over(PARTITION by Departmentid
ORDER BY Salary desc) as rn
from Employee)as a
WHERE rn=2;