SELECT 3rd Highest Salary in SQL

To select 3rd highest salary in SQL, you can use the LIMIT clause in combination with the ORDER BY clause. SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2; We are assuming you have a table named employees with a column named salary that stores the salary information. We use the … Read more