题目:
答案:
select b.Name as 'Employee' from Employee as a , Employee as b where a.Id = b.managerId and b.Salary > a. Salary
解释:
此题输出形式为
要将Name 改为 Employee 并且是员工和经理相互比较 用两个表 id 和 managerid 一样 在比较 salary即可
select b.Name as 'Employee' from Employee as a , Employee as b where a.Id = b.managerId and b.Salary > a. Salary
解释:
此题输出形式为
要将Name 改为 Employee 并且是员工和经理相互比较 用两个表 id 和 managerid 一样 在比较 salary即可