110,534
社区成员
发帖
与我相关
我的任务
分享
UPDATE TB SET [value]=(SELECT SUM([value]) FROM TB WHERE ID<'03') WHERE ID='03'
UPDATE TB SET [value]=(SELECT SUM([value]) FROM TB WHERE ID<'03') WHERE ID='04'
UPDATE TB SET [value]=
(SELECT SUM([value]) FROM TB WHERE ID<'03')*(SELECT[VALUE] FROM TB WHERE ID='02')+(SELECT [VALUE] FROM TB WHERE ID='04' )
WHERE ID='05'
在数据库好处理吧!