Top SQL Interview Questions
2 minutes
27 June 2025
Write an SQL query to fetch the second-highest salary from an employees table. SELECT MAX(salary) AS SecondHighestSalary FROM employees WHERE salary < (SELECT MAX(salary) FROM employees); SELECT salary AS SecondHighestSalary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1; SELECT salary AS SecondHighestSalary FROM ( SELECT salary, row_number() OVER...