摘要： (1)select name,subject,result from resultInfo(2)select name,sum(result) from resultInfo group by name（3）select name ,sum(result) as 总分 from resultInfo group by name with cubeselect case when grouping(name)=1 then '总计' else name end as 姓名 ,sum(result) as 总分 from resultInfo group by name with 阅读全文