select id,number,dense_rank() over(order by number desc) as t_rank from passing_number
order by t_rank,id
排序函数：dense_rank(),按值排序，值相等时会重复，不会产生空位；