Question

急求SQL语句，汇总sc表中每个学生的学号及总成绩

Answer 1

select 学号,sum(成绩) as 总成绩 from sc group by 学号

Answer 2

select 学号,sum(成绩) 总成绩 from sc group by sc.学号.

Answer 3

select sc.s_no,sum(sc.score) from sc group by sc.s_no;