Leetcode Employees Earning More Than Their Managers problem solution

YASH PAL,

In this Leetcode Employees Earning More Than Their Managers problem solution, we have given the Employee table, write a SQL query that finds out employees who earn more than their managers.

Leetcode Employees Earning More Than Their Managers problem solution

Problem solution in Mysql.

SELECT Name Employee FROM Employee a
WHERE Salary > (SELECT Salary FROM Employee b WHERE a.ManagerId = b.Id)

Problem solution in Oracle.

select e.name Employee from employee e , employee m 
where e.managerid = m.id
and e.salary > m.salary

Problem solution using Join.

select 
e1.Name
from Employee e1 join Employee e2
on e1.ManagerId = e2.Id and e1.Salary>e2.Salary

coding problems