select
c.emp_no,
c.salary
from salaries c
join
     (select 
        salary,
        row_number()over(order by a.salary desc) rt
        from (
                select
                    distinct salary
                from salaries
            )a
         )b
on c.salary = b.salary
where b.rt=2
order by c.emp_no