注意order by可以接多个列

select id, number, dense_rank() over(order by number desc) t_rank
from passing_number
order by t_rank, id;