So far, you have seen two main groups of calculations:
-
Most calculations have been based on table columns: For each row, a value is calculated from one or more columns.
-
Aggregate queries are used to summarize rows: For the whole table, some or all rows are summarized.
Window functions are a group of functions which add row data as columns. We’ll be working with three groups of window functions:
-
Aggregate functions: You would normally get aggregates as a separate summary of the table data, but aggregate window functions ...
