不用数组会更方便。用临时表
create cursor lsb(a c(1),b n(4))
sele lsb
appe blank
repl a with "a",b with 10
appe blank
repl a with "a",b with 590
appe blank
repl a with "b",b with 200
appe blank
repl a with "c",b with 200
appe blank
repl a with "c",b with 300select sum(a) as a,sum(b) as b from lsb group by a into array yourarray或者不防到数组里,也放到临时表
select sum(a) as a,sum(b) as b from lsb group by a into cursor linsisele linsi
brow
create cursor lsb(a c(1),b n(4))
sele lsb
appe blank
repl a with "a",b with 10
appe blank
repl a with "a",b with 590
appe blank
repl a with "b",b with 200
appe blank
repl a with "c",b with 200
appe blank
repl a with "c",b with 300select sum(a) as a,sum(b) as b from lsb group by a into array yourarray或者不防到数组里,也放到临时表
select sum(a) as a,sum(b) as b from lsb group by a into cursor linsisele linsi
brow
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货