1.计算每个人的总成绩并排名
select CourseID,sum(Score) as allscore from ScoreInformation group by CourseID order by allscoreselect CourseID,sum(Score) as allsco
阅读背景：
统计成绩SQL语句
来源：互联网
分享到：
