首页 > 技术文章 > 181. Employees Earning More Than Their Managers

aguai1992 2016-08-28 10:57 原文

# Write your MySQL query statement below
select E.name Employee 
from Employee as E,Employee as M
where E.ManagerId=M.Id 
and E.Salary>M.Salary 

 

推荐阅读