Skip to content

Latest commit

 

History

History
19 lines (14 loc) · 303 Bytes

Employees Earning More Than Their Managers.md

File metadata and controls

19 lines (14 loc) · 303 Bytes

Hint

Use a SELF JOIN

MySQL Solution

SELECT
    a.Name AS Employee
FROM
    Employee AS a,
    Employee AS b
WHERE
    a.ManagerId = b.Id AND a.Salary > b.Salary

Links