To find the second highest salary in a table, use the SQL query with the MAX function and a subquery.

• Use the MAX function to find the highest salary in the table

• Use a subquery to exclude the highest s...read more

Select * from (select name,salary, dense_rank over (order by salary desc) as rank from employees) where rank=2;

2nth....nth