CODE EXAMPLE FOR SQL

2nd max salary query in sql

select *from employee 
group by salary 
order by  salary desc limit 1,1;