test.employee doesn't exsit, whats going on....

  • 0
    select d.Name as 'department', e1.Name as 'employee', e1.Salary
    from Emloyee e1 join Department d on d.Id = e1.DepartmentId
    where 3 > (
    	select count(distinct e2.Salary) 
    	from Employee e2 
    	where e2.Salary > e1.Salary 
    		e1.DepartmentId = e2.DepartmentId

    The above code is almost the same as the solution posted, I did lots of test, and finally made it to the solution....but it tells me the result is test.employee doesn't exsit..

    Anybody have had the same situation?

Log in to reply

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