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

2025-01-19 10:23:21
推荐回答(2个)
回答1:

SELECT Name
,SUM(Score)

FROM StudentScore
GROUP BY Name

回答2:

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