一、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:
一、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: