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