刷题通过的题目排名

简介

联表查询, 相当于 inner join?
不是 因为不能用on

select a.id, a.number, count(distinct b.number) as t_rank
from passing_number as a, passing_number as b
where a.number<=b.number
group by a.id
order by a.number desc,a.id asc;