SELECT emp_no, salary, dense_rank()over(order by salary desc) as t_rank
FROM salaries