就是将number进行降序排序,同时排序序号不会占用行数(dense_rank)

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