Window functions are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is not flexible enough: for example incremental totals, moving averages, etc.

The latest features introduced in PostgreSQL complete the implementation according to the SQL:2011 standard, adding capabilities such as range frames, GROUPS mode and exclusions.

In order to discuss this topic in detail, 2ndQuadrant hosted the “Business Intelligence with Window Functions in PostgreSQL” webinar, giving an overview of Window Functions, how to use them in PostgreSQL, their impact on business intelligence along with discussing specific features and detailed examples.

The webinar was presented by Gianni Ciolli, Head of Professional Services at 2ndQuadrant.

Those who weren’t able to attend the live event can now view the recording here.

For any questions, comments, or feedback, please visit our website or send an email to [email protected].