select
    emp_no,
    salary
from
    (
        select
            emp_no,
            salary,
            rank() over (
                order by
                    salary desc
            ) as ranking
        from
            salaries
    ) s
where
    s.ranking = '2'