CAST(sum(IIF((column5>0), 1, 0)) AS N(4)) AS File5,; CAST(sum(IIF((column8>0), 1, 0)) AS N(4)) AS File6;>hi all,
>SELECT column27,; > CAST(sum(IIF((column5>0) , column5, 0)) AS N(14,2)) AS File3,; > CAST(sum(IIF((column8>0) , column8, 0)) AS N(14,2)) AS File4,; > CAST(count(IIF((column5>0) , column5, 0)) AS N(4)) AS File5,; > CAST(count(IIF((column8>0) , column8, 0)) AS N(4)) AS File6; > FROM wtable2 ; >GROUP BY column27; >INTO CURSOR crsTest >index on padl(alltr(column27),10,"0") tag aaa >BROW NORMAL >>
>Column27 column3 column4 Column5 Column8 >9 a 42 12 0 >9 a 42 0 15 >9 a 42 0 12 >9 a 42 0 7 >9 a 42 5 0 >9 a . 0 3 >9 a . 0 1 >9 a . 0 1 >9 a . 0 4 >9 a 42 13 0 > >result as >Column27 sum(column5) sum(column8) count(column5) count(column8) > 9 30 4 3 7 >