10倍提升技术面试通过率:LeetCode企业题库的系统性备战指南 【免费下载链接】LeetCode-Questions-CompanyWise Contains Company Wise Questions sorted based on Frequency and all time 项目地址:
题目编写解决方案,找出收入比经理高的员工。以 任意顺序 返回结果表。结果格式如下所示。代码
select a.name as 'Employee' from Employee as a,Employee as b
where a.ManagerId=b.Id and a.salary>b.salary;知识点
MySQL中的AS关键字主要用于为列和表设置