社区微信群开通啦,扫一扫抢先加入社区官方微信群
社区微信群
表结构
按各科成绩进行排序,并显示排名(实现不完全)
要求结果如下
sql写法 select a.* from (SELECT c_id,s_score,@i:=@i +1 as i保留排名 FROM (select @i:=0)s,Score WHERE c_id='01'ORDER BY s_score desc) a UNION all
select b.* from (SELECT c_id,s_score,@t:=@t +1 as i保留排名 FROM (select @t:=0)s,Score WHERE c_id='02' ORDER BY s_score desc)b UNION all
select c.* from (SELECT c_id,s_score,@q:=@q +1 as i保留排名 FROM (select @q:=0)s,Score WHERE c_id='03' ORDER BY s_score desc)c;
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!