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  阅读(112)  评论(0编辑  收藏  举报