SQL query to find second highest salary.

• Use ORDER BY clause in descending order to sort the salaries

• Use LIMIT 1,1 to select the second highest salary

• Example: SELECT salary FROM employees ORDER BY sala...read more

select max (salary) from table_name where salary not in ( select max(salary) from table_name;