Forum

Forums
Oracle
Interview Questions...
SQL Query to Find t...
 
Share:
Notifications
Clear all

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

 
    Last Post
RSS

Posts: 27
 KV Kumar
Admin
Topic starter
Jul 27, 2020 12:16 pm
(@vinodkrsetty)
Eminent Member
Joined: 4 years ago

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

Please help. 

This topic was modified 2 years ago by KV Kumar
Topic Tags
findemployeedetails earning morethansupervisor
1 Reply
Posts: 18
 VK
Jul 27, 2020 1:24 pm
(@vinodkrsetty5895)
Active Member
Joined: 3 years 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

Self Learning Video Tutorials - Software Course

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  findemployeedetails (1) , earning (1) , morethansupervisor (1) ,
Share: