第1个回答 2013-01-09
merge into table a using
(select max(编号) 编号, sum(nan) nan, sum(nv) nv from table) b
on(a.编号=b.编号)
when matched then update set a.nan=b.nan, a.nv=b.nv
when not matched then insert values (b.编号+1,b.nan,b.nv,'合计','办公室')
--↑oracle9以后版本这行可以不加,来自:求助得到的回答本回答被网友采纳