Get Runtime error when used inner join, removed it get AC!!!!


  • 0
    A

    when I used the following code:

    select Emp.Name from Employee Emp inner join Employee Mgr
    on Emp.ManagerId = Mgr.Id
    where Emp.Salary > Mgr.Salary;
    

    i got runtime error!, when removed the 'inner' like this:

    select Emp.Name from Employee Emp join Employee Mgr
    on Emp.ManagerId = Mgr.Id
    where Emp.Salary > Mgr.Salary;
    

    i got AC!!!!, can anyone explain that to me!???


  • 0
    L

    I just run the same code several times but the result of run time all are different.


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.