难度:简单
题目描述:
Employee 表包含所有员工,他们的经理也属于员工。每个员工都有一个 Id,此外还有一列对应员工的经理的 Id。
给定 Employee 表,编写一个 SQL 查询,该查询可以获取收入超过他们经理的员工的姓名。在上面的表格中,Joe 是唯一一个收入超过他的经理的员工。
题解:
方法一:
# Write your MySQL query statement below
SELECT
a.Name as Employee
FROM
Employee as a,
Employee as b
Where
a. ManagerId=b.Id
And a.Salary>b.Salary
方法二:
# Write your MySQL query statement below
SELECT
a.Name as Employee
FROM
Employee as a JOIN Employee as b
ON a. ManagerId=b.Id
AND a.Salary>b.Salary