本文最后更新于 137 天前。
子查询，as是为了依照题目要求将输出的表中name改名为employee
SELECT name as Employee
FROM Employee e1
WHERE salary > (
SELECT salary
FROM Employee e2
WHERE e1.managerId = e2.id
)
暂无评论
子查询，as是为了依照题目要求将输出的表中name改名为employee
SELECT name as Employee
FROM Employee e1
WHERE salary > (
SELECT salary
FROM Employee e2
WHERE e1.managerId = e2.id
)
