Write an SQL query to find the second highest salary of an employee from the Employees table.

Question

Accepted Answer

This SQL query retrieves the second highest salary from the Employees table using a subquery.

Use a subquery to find distinct salaries: SELECT DISTINCT salary FROM Employees.
Order the salaries in descending order and limit the result to the second row: SELECT DISTINCT salary FROM Employees ORDER BY salary DESC LIMIT 1 OFFSET 1.
Alternatively, use the 'MAX' function with a subquery: SELECT MAX(salary) FROM Employees WHERE salary < (SELECT MAX(salary) FROM Employees).
Ensure to handle cases where there may be fewer than two distinct salaries.

Interview Questions from Popular Companies