Window Function Basics – PARTITION BY

One of the things that I’ve done over the last year to improve my T-SQL skills is learn to work with the various window functions that exist in the language. These were added in 2012 and there have been a number of improvements across the last decade. Since I struggled to understand some of the concepts early on, I decided to write a few articles on some basic concepts of how these functions work.

This article will look at the partitioning clause inside a window function with a few examples that I hope will help you learn how to better