第二个排序为什么会按照s_id 进行排序,该怎么理解这两个代码
select a.s_id,a.s_score ,a.c_id, @i:=@i+1 as rank from score a,student b ,(select @i:=0)s
where a.c_id='01' and a.s_id=b.s_id order by a.s_score desc;
select a.s_id ,a.s_score ,a.c_id, @i:=@i+1 as rank from score a,course b ,(select @i:=0)s
where a.c_id ='01' and a.c_id=b.c_id order by a.s_score desc;