select emp_no,salary,dense_ranK() over (order by salary desc) as t_rank
from salaries
where to_date = '9999-01-01'
order by t_rank,emp_no;