181.超过经理收入的员工
解析
select a.Name as Employee from Employee as a, Employee as b
where a.ManagerId = b.Id && a.Salary > b.Salary
把Employ看作2个表,a为员工表,b为经理表,且给员工也默认设置有ManagerId
通过select查询 Name 并且 as为 Employee
用where 判断 员工Id 和 对应经理Id 并且 工资还要大约经理
select a.Name as Employee from Employee as a, Employee as b
where a.ManagerId = b.Id && a.Salary > b.Salary
把Employ看作2个表,a为员工表,b为经理表,且给员工也默认设置有ManagerId
通过select查询 Name 并且 as为 Employee
用where 判断 员工Id 和 对应经理Id 并且 工资还要大约经理