MySQL/181. Employees Earning More Than Their Managers 超过经理收入的员工

题目

---

 

 

 

代码部分一（1936ms）

SELECt
      a.Name AS Employee
      FROM Employee a 
      WHERE a.Salary>(
          SELECT 
                b.Salary 
                FROM Employee b 
                WHERE a.ManagerId=b.Id);

 

代码部分二（732ms）

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

 

代码部分三（584ms）

SELECT
      a.Name AS Employee
      From Employee AS a
      JOIN Employee AS b ON a.ManagerId=b.Id
      AND a.Salary>b.Salary;