SELECT Office_Expense_DID, Claim_Amount,
SUM(Claim_Amount) OVER (ORDER BY Office_Expense_DID ROWS UNBOUNDED PRECEDING) AS CumulativeAmount
FROM Imprest_OfficeExpense_Details
ORDER BY Office_Expense_DID;
SELECT Office_Expense_DID, Claim_Amount,
SUM(Claim_Amount) OVER (ORDER BY Office_Expense_DID ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) AS CumulativeAmount
FROM Imprest_OfficeExpense_Details
ORDER BY Office_Expense_DID;
Output
![Output]()