LeetCode / 185. Department Top Three Salaries / MySQL / Hard
2023. 12. 20. 09:24
📚문제 📝풀이 # Write your MySQL query statement below SELECT Department , Employee , Salary FROM (SELECT d.name AS Department , e.name AS Employee , e.salary AS Salary , DENSE_RANK() OVER(PARTITION BY d.name ORDER BY e.salary DESC) AS rnk FROM Employee e JOIN Department d ON e.departmentId = d.id) rnk_etc WHERE rnk
