极简leetcode笔记,主要想记录自己写的辣鸡代码
select a.name as Employee from Employee as a,Employee as b where a.managerId=b.id and a.salary>b.salary;
或使用join(执行结果显示使用join时,执行用时更短)
select a.name as Employee from Employee as a join Employee as b where a.managerId=b.id and a.salary>b.salary;