Question

Given Employee(EmpID, Name, Salary, ManagerI

  • D , which query correctly lists employees who earn more than their own manager?
A SELECT Name FROM Employee WHERE Salary > (SELECT AVG(Salary) FROM Employee)
B SELECT e.Name FROM Employee e JOIN Employee m ON e.ManagerID = m.EmpID WHERE e.Salary > m.Salary
C SELECT e.Name FROM Employee e, Employee m WHERE e.ManagerID = m.ManagerID AND e.Salary > m.Salary
D SELECT e.Name FROM Employee e JOIN Employee m ON e.ManagerID = m.ManagerID WHERE e.Salary < m.Salary
E SELECT e.Name FROM Employee e JOIN Employee m ON e.EmpID = m.ManagerID WHERE e.Salary > m.Salary
Practice Next

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)