insert acumulative
563850May 26 2010 — edited May 26 2010Hi all,
Need help for simple question,
select * from test;
1 | 2
1 | 3
1 | 4
I need create table with acumulative results, for example.
create test2 from test
1 | 2
1 | 2+3
1 | 3+4
create test3 from test2
1 | 2
1 | 5+2
1 | 7+5
how can create an insert sql for increment acumulative results in test table?
Regards.