with t as(
    select emp_no,
salary,
dense_rank() over(order by salary desc) as salary_rank
from salaries
)

select emp_no,salary
from t 
where salary_rank=2