select emp_no, salary
,dense_rank() over(order by salary desc) t_rank
from salaries
order by salary desc,emp_no
select emp_no, salary
,dense_rank() over(order by salary desc) t_rank
from salaries
order by salary desc,emp_no
牛客博客，记录你的成长
京公网安备 11010502036488号