1.分析
count计数的时候要去重，两个排序。

2.代码

select p1.id ,p1.number,
(select count(distinct p2.number) from passing_number as p2 where p2.number >= p1.number)         
as t_rank
from passing_number as p1
order by number desc,id asc