怎么把计算后的数值在插到表中...

[ProgramFuny]

一个学生考试成绩的统计表 ：主键stuNum 还有两个成绩列如（subject1 ，subject2），现在要计算出均分，在在表后加上一列 用于存储均分，该怎么写呢~~~~

[建哥聊IT]

insert 成绩表
select avg(subject1),avg(subject2)
from 成绩表

[paoluo]

？？

Select *,(subject1+subject)/2 As 均分 From 学生考试成绩

[建哥聊IT]

应该是这样:
create table #tbl(sub1,sub2)
insert #tbl
select subject1,subject2
from 成绩表
uniion all
select avg(subject1),avg(subject2)
from 成绩表

[kisa99]

select *,avg(subject1+subject2) as 均分 from table

[LouisXIV]

create table test
(
stuNum int,
subject1 int,
subject2 int
)
insert into test
select 1,70,80 union all
select 2,80,94 union all
select 3,60,71

select * from test

alter table test add average as (subject1+subject2)/2

select * from test

go
drop table test

/*
stuNum subject1 subject2
----------- ----------- -----------
1 70 80
2 80 94
3 60 71

stuNum subject1 subject2 average
----------- ----------- ----------- -----------
1 70 80 75
2 80 94 87
3 60 71 65
*/

[playwarcraft]

alter table 统计表 add avgs1_s2 null
update 统计表 set avgs1_s2=(subject1+subject2)/2.0
select * from 统计表

[kisa99]

我的错了，应该是
Select *,(subject1+subject)/2 As 均分 From 学生考试成绩

[小炮叔]

select *,avg(subject1+subject2) as 平均分 from 学生成绩表