Andy Brownsword breaks things up:
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.
Click through for Andy’s motivation, which is a way that absolutely will not work the way you want it to.