求一个sql语句

作者: miraclestar   发布时间: 2011-07-08

update tb A1 
,(
select B,sum(A) as C
from tb
group by B)A2
set A1.C=A2.C
where A1.B=A2.B

作者: rucypli   发布时间: 2011-07-08

Update table1 inner join (select b,sum(a) as c from table1 group by b) t on table1.b=b.b
Set table1.c=b.c

作者: ACMAIN_CHM   发布时间: 2011-07-08