Question

Write an Oracle SQL query to find employees who earn more than their managers.

Answer 1

SELECT emp.*

FROM Employee emp

INNER JOIN Employee mgr ON emp.manager_id = mgr.employee_id

WHERE emp.salary > mgr.salary;