This is an example query to to get cummulative or running totals of financial related data such as sales, payments, tax etc. using the Oracle SUM(..) OVER(ORDER BY ...) syntax. Below is a simple running total of consecutive numbers up to 10. Next example shows the use of this syntax in a typical data warehouse fact table. |
74048