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 operation is NOT part of relational algebra?
Relation R has 20 tuples and relation S has 15 tuples, with no common attributes between them. What is the cardinality (number of resulting tuples) of R x ...
In DBMS, which scheduling method ensures serializability of transactions?
Which of the following is NOT a common type of error encountered during software development?
Relation R(Student, Course, Hobby) stores every course a student takes and every hobby they have, independently of each other, producing a full cross-produ...
Under READ COMMITTED isolation, Transaction T1 executes a query 'SELECT * FROM Accounts WHERE balance > 50000' and gets 5 rows. Before T1 re-executes the i...
Which SQL command is used to retrieve data from a table?
Which normal form in relational database design specifically eliminates transitive dependency of non-key attributes on the primary key?
A program needs to process elements from a `Queue` until it becomes empty. Which control flow structure is most suitable for this task?
In SQL, which clause is used to filter groups of rows after aggregate functions (such as SUM, COUNT, or AVG) have been applied?

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