>*mytable >empno file no val1 val2 >1 2 6 500 80 >1 2 28 100 50 >1 3 10 200 70 >2 2 8 100 40 >2 4 18 150 60 > >>
>empno count1 file no val1 val2 sum1(val1+val2) >1 3 7 44 800 200 1000 >2 2 6 26 250 100 350 >>
SELECT empno, CNT(*), SUM(File), SUM(Val1), SUM(Val2), SUM(Val1 + Val2) ; FROM MyTable ; GROUP BY EmpNO ; INTO CURSOR MyResultTamar