select 
    emp_no ,
    salary
from (
    select
        emp_no ,
        salary ,
        dense_rank() over(order by salary desc) as rank_
    from salaries
) as t
where rank_ =2