[SQL]employees-earning-more-than-their-managers

Q_jihe 2023. 8. 17. 15:05

https://leetcode.com/problems/employees-earning-more-than-their-managers

Employees Earning More Than Their Managers - LeetCode

Can you solve this real interview question? Employees Earning More Than Their Managers - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | salary | int | | managerId | int | +------

leetcode.com

SELECT e1.Name AS Employee
FROM Employee e1
JOIN Employee e2 ON e1.ManagerId = e2.Id 
    AND e1.Salary > e2.Salary