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