LeetCode | MySQL | 185. Department Top Three Salaries

leetcode.com/problems/department-top-three-salaries/

Department Top Three Salaries - LeetCode

/* RANK(), DENSE_RANK() */
SELECT t.Employee,
       t.Department,
        t.Salary
FROM(
    SELECT department.name AS department
        , employee.name AS employee
        , employee.salary AS salary
        , DENSE_RANK() OVER (PARTITION BY departmentid ORDER BY salary DESC) AS dr
    FROM employee
        INNER JOIN department ON employee.DepartmentId = department.id
)t
WHERE t.dr <= 3