所有Leetcode题目不定期汇总在 Github, 欢迎大家批评指正,讨论交流。
# Write your MySQL query statement below
# method one where 语句
# select
# a.name AS 'Employee'
# from
# Employee AS a,
# Employee AS b
# where
# a.ManagerId = b.Id
# AND a.Salary > b.Salary
# method two join 语句
SELECT
a.name AS 'Employee'
FROM Employee AS a JOIN Employee AS b
ON a.ManagerId = b.Id
AND a.Salary > b.Salary
所有Leetcode题目不定期汇总在 Github, 欢迎大家批评指正,讨论交流。