场景:
学生的数学成绩如下表jm_student所示:
对学生的成绩进行排名,分值越高,排名越靠前,相同的分值,排名相同。
sql如下:
select @rowno:=@rowno+1 as rowno,
if(@records=records,@rank,@rank:=@rank+1) as rank,
@records:=records,
k.id,k.records,k.name
from (select * from jm_student u order by u.records desc) k,
(select @rank:=0,@rowno:=0,&#