hi all,

i need help to create new table have records as..

*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

*result new cursor or table

empno     count1   file          no       val1        val2      sum1(val1+val2)    
1               3          7           44       800         200           1000                
2               2          6           26       250        100            350

thanks