select emp_no,salary
from
(select emp_no,salary,
dense_rank() over (order by salary desc)as rnk
from salaries)as b
where b.rnk=2