185. 部门工资前三高的所有员工

了解rank和dense_rank的区别

SELECT D.name as Department,E.name as Employee,salary FROM
(SELECT *,dense_rank() over(partition by departmentId order by salary desc) rk
FROM Employee) E inner join Department D
on E.DepartmentId = D.id and E.rank <=3