create cursor tt(id n(3),yw n(3),sx n(3),yy n(3))
insert into tt values(1,103,123,145)
insert into tt values(2,113,103,140)
insert into tt values(3,133,73,135)
insert into tt values(4,93,143,125)
insert into tt values(5,83,132,115)

insert into tt(id,yw,sx,yy) select sum(id),sum(yw),sum(sx),sum(yy) from tt
browse

谢谢哈，我试试，我是新手还看不太懂哈。

二楼的高手是倒写手法：
一般新手都是
 select sum(id),sum(yw),sum(sx),sum(yy) from tt insert into tt(id,yw,sx,yy)