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