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