就是将number进行降序排序,同时排序序号不会占用行数(dense_rank)
select *, dense_rank() over(order by number desc) from passing_number;