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

按要求窗口函数排一下就行