Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

M. SimonLeveling Up with SQLhttps://doi.org/10.1007/978-1-4842-9685-1_8

8. Window Functions

Mark Simon¹  

(1)

Ivanhoe VIC, VIC, Australia

 

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 ...