A

Arogya • 3.19K Points
Extraordinary

Q. Find second highest salary in EMPLOYEES table.

  • (A) SELECT MAX(salary) FROM employees;
  • (B) SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
  • (C) SELECT salary FROM employees;
  • (D) SELECT MIN(salary) FROM employees;
Explanation by: Arogya
Subquery removes highest salary then finds next maximum.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.