题解 | #刷题通过的题目排名#
刷题通过的题目排名
http://www.nowcoder.com/practice/cd2e10a588dc4c1db0407d0bf63394f3
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