这样OK不

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