leetcode sql No.181超过经理收入的员工

常规解法：
select u0.name as Employee from Employee u0 where salary >(select u1.salary from employee u1 where u1.id=u0.managerid)
评论区的一种快解法 用 inner join :
select a.name as Employee
from employee a inner join employee b on a.managerid = b.id 
and a.salary > b.salary
作者：bu-fu-hao-shi-guang
链接：https://leetcode-cn.com/problems/two-sum/solution/san-chong-jie-fa-inner-joinzui-kuai-zi-cha-xun-exi/
来源：力扣（LeetCode）
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。