Link Search Menu Expand Document

181. Employees Earning More Than Their Managers

Solution Code

MySQL

SELECT E1.Name as 'Employee'
FROM Employee as E1, Employee as E2
WHERE E1.ManagerId = E2.Id AND E1.Salary > E2.Salary;

© 2023. All rights reserved.