select emp_no, salary
from (
    select *, dense_rank() over (order by salary desc) as dr
    from salaries
) temp
where dr=2
order by emp_no