这个题简单啊,不应该是较难吧
select emp_no,salary,dense_rank()over(order by salary desc)
from salaries
order by salary desc,emp_no