select emp_no,salary
from
(select emp_no,salary,rank() over(order by salary desc) t
from salaries
where to_date='9999-01-01') t1
where t=2