+------------+----------+--------+
| Department | Employee | Salary |
+------------+----------+--------+
| IT | Max | 90000 |
| IT | Randy | 85000 |
| IT | Joe | 85000 |
| IT | Will | 70000 |
| Sales | Henry | 80000 |
| Sales | Sam | 60000 |
+------------+----------+--------+
解释:
IT 部门中,Max 获得了最高的工资,Randy 和 Joe 都拿到了第二高的工资,Will 的工资排第三。销售部门(Sales)只有两名员工,Henry 的工资最高,Sam 的工资排第二。
select Department, Employee, Salary from
(
select
Department.Name Department,
Employee.Name Employee,
Employee.Salary,
dense_rank() over (partition by DepartmentId order by Salary desc) rk
from Employee inner join Department on Employee.DepartmentId = Department.Id
) t
where rk <=3