sql script

select emp_no, salary, dense_rank() over(order by salary desc) as t_rank
from salaries

key point

dense_rank() function