|
#2
吹水佬2021-06-11 20:04
|
create cursor b1 (m1 c(2),m2 c(2),m3 c(2),含M数 N(2))
insert into b1 values ("M1","M2","",2)
insert into b1 values ("","M2","M3",2)
insert into b1 values ("M1","M2","M3",3)
insert into b1 values ("M1","M2","",2)
insert into b1 values ("","M2","M3",2)
insert into b1 values ("M1","M2","M3",3)
可以用:
REPLACE ALL 含M数 WITH OCCURS('M',m1+m2+m3)
一条语句就统计出结果。
create cursor b2 (m1 N(2),m2 N(2),m3 N(2),及格数 N(2))
insert into b2 values (61,54,72,2)
insert into b2 values (48,85,73,2)
insert into b2 values (67,72,69,3)
insert into b2 values (61,54,72,2)
insert into b2 values (48,85,73,2)
insert into b2 values (67,72,69,3)
可否像上面那样用一条语句直接统计m1、m2、m3中“>=60”的数到"及格数"中否?
