常规解法:
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)
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。
leetcode sql No.181超过经理收入的员工
最新推荐文章于 2022-04-27 08:28:40 发布