员工"/>
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;
更多推荐
MySQL/181. Employees Earning More Than Their Managers 超过经理收入的员工
发布评论