Find Third Highest Salary Employees Table

Find the employee with the third-highest salary.

sql

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

This query sorts the "employees" table by "salary" in descending order and uses the LIMIT and OFFSET clauses to skip the first two records, thereby returning the third-highest salary.

PromptDB can make mistakes. Please double-check responses.