想高手,盼高手,sql行更新
drop table test;
Create table test (id integer,name varchar2(3),v1 integer ,v2 integer);
insert into test values (1,'aaa',10,8);
insert into test values (2,'aaa',5,2);
insert into test values (3,'aaa',2,3);
insert into test values (4,'aaa',0,0);
insert into test values (1,'bbb',7,8);
insert into test values (2,'bbb',5,2);
insert into test values (3,'bbb',1,3);
insert into test values (4,'bbb',0,0);
commit;
更新id=4的行,关系是id=4行(v1,v2)=(name对应id=)1行-(name对应id=)2行+(name对应id=)3行
更新后应为结果
ID NAM V1 V2
------ --- ---------- ----------
1 aaa 10 8
2 aaa 5 2
3 aaa 2 3
4 aaa 7 9
1 bbb 7 8
2 bbb 5 2
3 bbb 1 3
4 bbb 3 9