select emp_no,salary from
(select emp_no,
salary,
dense_rank() over (order by salary
DESC) as rk
from salaries) as A
where rk = 2
order by emp_no ASC