hi,

Is there any SQL query to cumilative add a field of a table for every row. For example i have this

iID iAmount
1 1000
2 1500
3 2000


and the query should result in this

iID iAmount iSum
1 1000 1000
2 1500 2500
3 2000 4500

In Oracle that would be:

select iid, iamount, sum(iamount) over (order by iid) isum
from ...;

Thanks,


Nasos