mysql查询总分前10名_mysql中一张学生表，查询出单科成绩前十名学生的所有信息 和总分成绩前十名学生的所有信息 在线等...
学生名字为：name
查询单科成绩前十：mysql语句为：select * from student order by subject desc limit 10;
查询总分成绩前十：mysql语句为：select sum(subject) subject,name from student group by name order by subject desc limit 10;
select sum(subject) subject,name
