Question

Given a table Employees(EmpID, ManagerID, Salary), which SQL statement correctly returns the EmpID of every employee who earns strictly more than their direct manager?

Q: Answer-Given a table Employees(EmpID, ManagerID, Salary), which SQL statement correctly returns the EmpID o...

Each employees manager is the row whose EmpID equals the employees ManagerID, so the correct self-join condition is e.ManagerID m.EmpID, followed by comparing e.Salary m.Salary. Option A joins employees sharing the same manager peers, not the manager itself. Options B and C reverse the join direction, matching an employee to their subordinates rather than their manager. Option E compares against the average salary of an employees peer group, not the managers actual salary.

A SELECT e.EmpID FROM Employees e, Employees m WHERE e.ManagerID = m.ManagerID AND e.Salary > m.Salary;

B SELECT e.EmpID FROM Employees e LEFT JOIN Employees m ON e.EmpID = m.ManagerID WHERE e.Salary > m.Salary;

C SELECT e.EmpID FROM Employees e JOIN Employees m ON e.EmpID = m.ManagerID WHERE e.Salary > m.Salary;

D SELECT e.EmpID FROM Employees e JOIN Employees m ON e.ManagerID = m.EmpID WHERE e.Salary > m.Salary;

E SELECT e.EmpID FROM Employees e WHERE e.Salary > (SELECT AVG(Salary) FROM Employees m WHERE m.ManagerID = e.ManagerID);

Practice Next

More IT DBMS Questions

Which normal form eliminates transitive dependency?
A transaction T1 updates a row and then waits for a lock held by T2. T2 is waiting for a lock held by T1. What condition has occurred?
Consider the following Java code snippet public class Car { private String model; private int year; public Car(String model, int year) {...
What is 'query optimization' in DBMS?
Which of the following is a significant disadvantage of using a traditional file system compared to an RDBMS?
What is the primary purpose of a "Trigger" in a database?
What is context switching?
Given a relation R(A, B, C, D, E) and functional dependencies {A -> B, BC -> D, D -> E}. Which of the following is a candidate key for R?
In a database with a foreign key constraint defined using "ON DELETE CASCADE," what happens when a row in the parent (referenced) table is deleted?
Distributed transactions typically use which protocol for atomicity?

Hey! Ask a query

🎓

Think You're Ready for RBI Grade B?

RBI Grade B 2026 Phase 1 Memory Based Paper

200 Questions with Detailed Solutions
Section-wise Coverage (GA, English, Quant & Reasoning)

Download Now 100% Free PDF

Given a table Employees(EmpID, ManagerID, Salary), which SQL statement correctly returns the EmpID of every employee who earns strictly more than their direct manager?

Detailed Solution

More IT DBMS Questions

Hey! Ask a query

Please Register/Login

RBI Grade B 2026 Phase 1 Memory Based Paper