1
计算每个人的总成绩并排名(要求显示字段:姓名,总成绩)
select name, SUM(score) as totalscore from stuscore group by name order by totalscore desc
(求和用sum,计算每个人按name 分组,排序order by)
2
计算每个人的总成绩并排名(要求显示字段: 学号,姓名,总成绩)
select stuid,SUM(score) as totalscore,name,d_date from stuscore group by name,stuid ,d_date order by totalscore desc
(如果一个表有很多字段呢?难道也要一个一个字段罗列出来group by?)
select distinct t1.name,t1.stuid,t2.allscore,t1.d_date from stuscore t1,
(
select stuid,sum(score) as allscore from stuscore group by stuid
)t2
where t1.stuid=t2.stuid
order by t2.allscore desc