题解 | #刷题通过的题目排名#

select
    id,
    number,
    dense_rank() over (
        order by
            number desc
    ) as t_rank
from
    passing_number

select
    p.id,
    number,
    c.num as t_rank
from
    passing_number p,
    (
        select
            a.id,
            count(distinct b.number) num
        from
            passing_number a
            join passing_number b on a.number <= b.number
        group by
            a.id
    ) c
where
    p.id = c.id
order by t_rank,p.id