2nd highest salary

Using dense_rank Using row_number                 2nd highest salary output on tool Retrieve 2nd highest salary from emp table 3rd highest salary using densk_rank Select * from (select dense_rank() over(order by…