我的开源
mysql分数排名,分数相同名次相同
比如给定一张scores
| id | score |
|---|---|
| 1 | 33.2 |
| 2 | 35.4 |
| 3 | 35.4 |
| 4 | 36.4 |
| 5 | 37.3 |
| 6 | 37.3 |
| 7 | 38.4 |
要求排序后输出
| 名次 | score |
|---|---|
| 1 | 38.4 |
| 2 | 37.3 |
| 2 | 37.3 |
| 3 | 36.4 |
| 4 | 35.4 |
| 4 | 35.4 |
| 5 | 33.2 |
select s.score ,
(select count(distinct m.score)+1 from scores m where m.score> s.score)
from scores s order by s.score desc