Question

sql同一张表中姓名相同的学生累加成绩

Answer 1

SELECT Name
,SUM(Score)

FROM StudentScore
GROUP BY Name

Answer 2

select name,sum(score) from student group by name

追问

只显示累加后的成绩

追答

select score from (select name,sum(score) from student group by name) ;