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

员工"/>

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

题目

代码部分一（1936ms）

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

代码部分二（732ms）

SELECTa.Name AS EmployeeFROM Employee AS a,Employee AS bWHERE a.ManagerId=b.Id AND a.Salary>b.Salary;

代码部分三（584ms）

SELECTa.Name AS EmployeeFrom Employee AS aJOIN Employee AS b ON a.ManagerId=b.IdAND a.Salary>b.Salary;