Solution#1
# Write your MySQL query statement below
SELECT E.Name AS Employee FROM Employee AS E INNER JOIN Employee AS M ON E.ManagerId = M.Id WHERE E.Salary > M.Salary
Problem
1. 注意查询结果的表名
本文介绍了一种使用MySQL查询语句来找出薪资高于其直接上级(经理)的员工的方法。通过内连接的方式,将Employee表自身进行连接,对比员工与其经理之间的薪资差异。
Solution#1
# Write your MySQL query statement below
SELECT E.Name AS Employee FROM Employee AS E INNER JOIN Employee AS M ON E.ManagerId = M.Id WHERE E.Salary > M.Salary
Problem
1. 注意查询结果的表名
1503
170
370

被折叠的 条评论
为什么被折叠?
