关于mysql查询出结果之后进行排序

1、在进行排序之后进行序号：
select (@i:=@i+1) as id,YX,ZY,ONE,TWO,THREE,FOUR,FIVE,SIX,SEVEN,EIGHT,NINE,TEN,SUM FROM ( select student.YX,student.ZY, sum(detail.ONE)/count() AS ONE,sum(detail.TWO)/count() AS TWO,sum(detail.THREE)/count() AS THREE,sum(detail.FOUR)/count() AS FOUR,sum(detail.FIVE)/count() AS FIVE,sum(detail.SIX)/count() AS SIX,sum(detail.SEVEN)/count() AS SEVEN,sum(detail.EIGHT)/count() AS EIGHT,sum(detail.NINE)/count() AS NINE,sum(detail.TEN)/count() AS TEN,sum(detail.ONE+detail.TWO+detail.THREE+detail.FOUR+detail.FIVE+detail.SIX+detail.SEVEN+detail.EIGHT+detail.NINE+detail.TEN)/count(*) AS SUM from pjxt_detailinfo detail left join pjxt_courseinfo course on detail.KCBH=course.KCBH join pjxt_teacherinfo teacher on teacher.JSBH=course.JSBH join pjxt_studentinfo student on student.XH=detail.XH where 1=1 GROUP BY ZY order by SUM desc ) c,(SELECT @i:=0) id ;
查询结果：