22Partitioning Data into Windows
In my head there are several windows, that I do know, but perhaps it is always the same one, open variously on the parading universe.
SAMUEL BECKETT
Topics in this Chapter
What You Can Do with a “Window” into Your Data
I’ve shown you several different ways that you can group and aggregate data, but I still haven’t shown you everything.
In earlier incarnations of the SQL standards, there really was no ability to work with data where the results depended on adjacent rows. It was always felt that the order of the rows didn’t matter, as long as you could match ...
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
