congr / world

2 stars 1 forks source link

LeetCode : 181. Employees Earning More Than Their Managers #488

Closed congr closed 5 years ago

congr commented 5 years ago

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

image

congr commented 5 years ago
# Write your MySQL query statement below
SELECT e1.Name as Employee
FROM Employee e1, Employee e2
WHERE e1.ManagerId = e2.Id And e1.Salary > e2.Salary