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