Question

Which of the following query will return the third-highest salary from an Employee table in SQL?

A SELECT salary FROM Employee ORDER BY salary DESC LIMIT 2, 1;
B SELECT MAX(salary) FROM Employee WHERE salary NOT IN (SELECT salary FROM Employee ORDER BY salary DESC LIMIT 2);
C SELECT DISTINCT salary FROM Employee ORDER BY salary DESC LIMIT 3, 1;
D SELECT salary FROM Employee WHERE salary = (SELECT salary FROM Employee ORDER BY salary DESC LIMIT 1 OFFSET 2);
E SELECT salary FROM Employee ORDER BY salary LIMIT 3;
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)