MySQL分数排名同分并列与不并列查询
程序员文章站
2022-09-15 15:27:41
Scores表 并列 不并列 ......
Scores表
| Id | Score | | 1 | 3.50 | | 2 | 3.65 | | 3 | 4.00 | | 4 | 3.85 | | 5 | 4.00 | | 6 | 3.65 |
并列
| Score | Rank | | 4.00 | 1 | | 4.00 | 1 | | 3.85 | 2 | | 3.65 | 3 | | 3.65 | 3 | | 3.50 | 4 |
select Score,(select count(distinct Score) from Scores as b where b.Score>a.Score)+1 as Rank from Scores a order by Score desc;
不并列
select Score,(@Numb:=@Numb+1)as Rank from Scores a,(select(@Numb:=0))b order by a.Score desc;
上一篇: Word2003文档里面打印指定页码
下一篇: 公司--)SQL框架内部用