select
emp_no,
salary
from
(select
emp_no,
salary,
rank()over(order by salary desc) as r
from salaries
) a
where r = 2
order by emp_no asc;