select count(stcd) as stcd,sum(wdta) as wdta from WQ_SDWAS_D 改为 select count(stcd) as stcd, sum(wdta) as wdta into stcdCnt, wdtaCnt from WQ_SDWAS_D ; (并且一开始声明stcdCnt, wdtaCnt 这两个为number或integer)
declare stcd number(12,2); wdta number(12,2); begin select count(stcd),sum(wdta) into stcd, wdta from WQ_SDWAS_D ; ... end;
还要在sql语句里加上 '合计' as s_name 但这个s_name 中是没有的select '合计' as s_name ,count(stcd) into stcd,sum(wdta) into wdta from WQ_SDWAS_D如果不加 into的话是不报错的,但加上into后 报错: 未找到预期的from关键字请各位再帮忙看看
select '合计' as s_name ,count(stcd) into stcd,sum(wdta) into wdta from WQ_SDWAS_D 什么意思?你兄弟到底要怎么样?:)
改为
select count(stcd) as stcd, sum(wdta) as wdta
into stcdCnt, wdtaCnt
from WQ_SDWAS_D ;
(并且一开始声明stcdCnt, wdtaCnt 这两个为number或integer)
stcd number(12,2);
wdta number(12,2);
begin
select count(stcd),sum(wdta) into stcd, wdta from WQ_SDWAS_D ;
...
end;
什么意思?你兄弟到底要怎么样?:)