Jul 27, 2020 12:16 pm
How to find the employees details who are earning more than their supervisor?
Please help.
1 Reply
Jul 27, 2020 1:24 pm
You can use below query to achieve this.
SELECT employee.*
FROM your_table_name AS employee
JOIN your_table_name AS manager ON manager.EMPNO = employee.MGR
WHERE employee.SAL > manager.SAL