[leetcode]181. Employees Earning More Than Their Managers

leetcode]181. Employees Earning More Than Their Managers"/>

[leetcode]181. Employees Earning More Than Their Managers

[leetcode]181. Employees Earning More Than Their Managers

Analysis

心情复杂~—— [ummmmmm~]

Given the Employee table, write a SQL query that finds out employees who earn more than their managers.

SQL语句的使用，在employee表格中找到薪水比其主管高的人，用自连接就可以了。

Implement

# 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;