mysql数据排名
一、mysql8.0以下
1、同分不同名
select name,score,ranking from (
select
name,
score,
@num3:=@num3+1 as ranking
from
(select id,name,score from user_score order by score desc) us,
(select @num3:=0) s
) t
2、同分同名
select name,score,ranking from (
select
原创
2020-08-01 16:04:40 ·
1226 阅读 ·
0 评论