How to find second highest salary from a table?

Answer 1

select all records, order by salary DESC and limit 2. then you can get the second record of the table using the programming language that you are using

Answer 2

select *from table t1 where 1=(select count(*) from table t2 where t2.sal>t1.max(sal))