Tag: WINDOW clause

SQL

Data Segmentation in SQL using Window Functions

Post author By Andy B.
Post date Jun 24, 2025
1 Comment on Data Segmentation in SQL using Window Functions

Sometimes you want to segment records. It may be splitting a customer base for marketing purposes, or segmenting a user base for a new feature. Good segmentation makes clean divisions in the data. In this post we’ll see a way to achieve that with a great deal of help from Window Functions. This post was […]

Tags Data Manipulation, Query Design, Querying, Segmentation, SQL, WINDOW clause, Window Functions

SQL

Cleaning Up Window Functions in SQL Server 2022

Post author By Andy B.
Post date Apr 1, 2025
2 Comments on Cleaning Up Window Functions in SQL Server 2022

Window functions allow us to perform a function across a set of rows in a result set, rather than how we might typically group them. In SQL Server 2022 we have a new clause available for our queries which can help tidy up how these are defined. We’ll use the sample table from the introduction to […]

Tags Querying, SQL, SQL Server 2022, Syntax, WINDOW clause, Window Functions