Let's start this blog with a personal opinion: I love windowing functions. Sounds like a good start of this post? Cool, let's keep going. What is a windowing function? There's a lot you can read about it, but in short it comes down to creating a subset in your query result where you apply a specific function. A simple example is generating a running sum.