当前位置:Gxlcms > 数据库问题 > Database 181. Employees Earning More Than Their Managers

Database 181. Employees Earning More Than Their Managers

时间:2021-07-01 10:21:17 帮助过:2人阅读

实现:

select e.Name as Employee from Employee e, Employee m

where e.ManagerId=m.Id and e.Salary>m.Salary

 

分析:

Runtime:1521ms beats 25.21%

这个蛮简单就是为什么效率这么低,应该是用的连接有问题,再看。

 

Database 181. Employees Earning More Than Their Managers

标签:

人气教程排行