2020-02-16 标签:sqlserver,统计,sql,语句,大全,收藏,计算,每个人,总成绩,并排,select,n,ame,sum,score,allscore,stuscore,group

1.计算每个人的总成绩并排名 select name,sum(score) as allscore from stuscore group by name order by allscore 2.计算每个人的总成绩并排名 select distinct t1.name,t1.stuid,t2.all