LeetCode数据库181 - 超过经理收入的员工 - where的用法

题目链接

https://leetcode-cn.com/problems/employees-earning-more-than-their-managers/

AC代码

select 
    x.Name as 'Employee'
from 
    Employee as x,Employee as y
where 
    x.ManagerId=y.id and x.Salary>y.Salary;