select a.id,a.number,
(
select count(distinct(number)) //数量上大于等于当前，且去重后计数
from passing_number b
where b.number>=a.number
)as t_rank //另外添加的一行
from passing_number a
order by a.number desc,a.id asc; //将原先的信息进行排序