February 2020
Intermediate to advanced
467 pages
8h 30m
English
One of the most useful features of analytic functions is the flexibility of the window clause, enabling aggregation of particular subsets of the data within a specific order. A classic subset that can be used for many purposes is the set of data from the beginning until the current row – if, for example, the sum aggregate function is used on that subset, you get an accumulated sum or rolling sum or running total (many names for the same thing).
The use cases are plenty; many financial reports need running totals. But a different practical use case that has been extremely ...
