对学生进行统计
select StudentNO,StudentName,ShuXueGrade,YuWenGrade,YingYuGrade,(ShuXueGrade+YuWenGrade+YingYuGrade) as 总成绩,(ShuXueGrade+YuWenGrade+YingYuGrade)/3.0 as 平均分 from TableName
对整班进行统计
select ClassName,Sum(ShuXueGrade) as ShuXueGrade,Sum(YuWenGrade) as YuWenGrade,
Sum(YingYuGrade) as YingYuGrade,Sum(ShuXueGrade)/Count(ClassName) as ShuXueGrade平均分,Sum(YuWenGrade)/Count(ClassName) as YuWenGrade平均分,Sum(YingYuGrade)/Count(ClassName) as YingYuGrade平均分 from TableName
Group by ClassName
select StudentNO,StudentName,ShuXueGrade,YuWenGrade,YingYuGrade,(ShuXueGrade+YuWenGrade+YingYuGrade) as 总成绩,(ShuXueGrade+YuWenGrade+YingYuGrade)/3.0 as 平均分 from TableName
对整班进行统计
select ClassName,Sum(ShuXueGrade) as ShuXueGrade,Sum(YuWenGrade) as YuWenGrade,
Sum(YingYuGrade) as YingYuGrade,Sum(ShuXueGrade)/Count(ClassName) as ShuXueGrade平均分,Sum(YuWenGrade)/Count(ClassName) as YuWenGrade平均分,Sum(YingYuGrade)/Count(ClassName) as YingYuGrade平均分 from TableName
Group by ClassName
from TableNameselect
Sum(ShuXueGrade) as ShuXueGrade,
Sum(YuWenGrade) as YuWenGrade,
Sum(YingYuGrade) as YingYuGrade,
Sum(ShuXueGrade)/Count(ClassName) as ShuXueGrade平均分,
Sum(YuWenGrade)/Count(ClassName) as YuWenGrade平均分,
Sum(YingYuGrade)/Count(ClassName) as YingYuGrade平均分
from TableName
select shuxuegrade, yuwengrade, yingyugrade from studentgrade
union all
(select sum(shuxuegrade), sum(yuwengrade), sum(yingyugrade) from studentgrade)
union all
(select sum(shuxuegrade)/count(*), sum(yuwengrade)/count(*), sum(yingyugrade)/count(*) from studentgrade)
Sum(ShuXueGrade) as ShuXueGrade,
Sum(YuWenGrade) as YuWenGrade,
Sum(YingYuGrade) as YingYuGrade,
Sum(ShuXueGrade)/(select count(ShuXueGrade) from TableName) as ShuXueGrade平均分,
Sum(YuWenGrade)/(select count(YuWenGrade) from TableName) as YuWenGrade平均分,
Sum(YingYuGrade)/(select count(YingYuGrade) from TableName) as YingYuGrade平均分
from TableName