[database_leetcode]181. Employees Earning More Than Their Manage
2021-03-05 08:11 作者:您是打尖兒還是住店呢 | 我要投稿
The?Employee?table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.
Given the?Employee?table, write a SQL query that finds out employees who earn more than their managers. For the above table, Joe is the only employee who earns more than his manager.
| Employee |?
| Joe ? ? ?|
做個(gè)自聯(lián)接即可；
問題屬于簡(jiǎn)單類
select a.name Employee
from employee a join employee b?
on a.managerid=b.id
where a.salary>b.salary
標(biāo)簽：
