Schedule - Nordic PGDay 2025
Window Functions Are Easier and More Powerful Than You Think
Date: 2025-03-18
Time: 16:05–16:55
Room: Main Room
Level: Intermediate
In some circles, window functions are considered "Advanced SQL". In this presentation, I will show you how easy and powerful they actually are.
We will start with the basic concept of partitions and orderings, then move on to simple frame specifications. Then we will look at more intricate frames and exclusion options, and how they can simplify quite a bit of application processing.
Finally, we will look at extensions that provide additional window functions to those defined by the SQL Standard, and take a peek at what the future might bring.
