Window Functions in SQL: Aggregating Values

Calculate running totals with window functions

Source: Photo by ChristopherPluta from Pixabay

When working with a table in SQL, it is often the case that one might wish to aggregate values, or calculate a running total among the values in the table.

In this article, we will investigate how this can be done using what is called a window function.