Find Second Highest Salary Employees Table

Find the employee with the second-highest salary.

sql

SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;

This query sorts the "employees" table by "salary" in descending order and uses the LIMIT and OFFSET clauses to skip the highest salary and retrieve the second-highest value.

PromptDB can make mistakes. Please double-check responses.