leetcode 181. Employees Earning More Than Their Manager 超过经理收入的员工 SQL where/join 语句的复习

所有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, 欢迎大家批评指正，讨论交流。