181. Employees Earning More Than Their Managers

# 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 

 

posted @ 2016-08-28 10:57  阿怪123  阅读(118)  评论(0)    收藏  举报