sum each 4 records from a query and insert result in a new column

[hubavka]

Hi,

I have problem figuring this out. Please help.

I have "n" records from a query

I want to sum up record 1 to 4, 2 to 5, 3 to 6, ... n-3 to n
and insert the results in the same table in a new colume

column new column

record 4 sum(record1-record4)
record 5 sum(record2-record5)

It will be great if I can do the insert the same time while I am looping over the query and making the calculation.

Any ideas?