Skip to toolbar

Forum

Find the employee d...
 
Notifications
Clear all

Find the employee details who are earning more than their supervisor?  


vinodkrsetty
Posts: 15
Admin
(@vinodkrsetty)
Member
Joined: 1 year ago

How to find the employee details who are earning more than their supervisor?

Please help. 

1 Reply
VK
Posts: 17
 VK
(@vinodkrsetty5895)
Active Member
Joined: 4 months ago

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

Reply

Leave a reply

Author Name

Author Email

Title *

Maximum allowed file size is 10MB

 
Preview 0 Revisions Saved
Share: