© Kathi Kellenberger, Clayton Groom, and Ed Pollack 2019
K. Kellenberger et al.Expert T-SQL Window Functions in SQL Server 2019https://doi.org/10.1007/978-1-4842-5197-3_5

5. Adding Frames to the Window

Kathi Kellenberger1 , Clayton Groom2 and Ed Pollack3
(1)
Edwardsville, IL, USA
(2)
Smithton, IL, USA
(3)
Albany, NY, USA
 

You have looked through the window and used it to write powerful queries to solve some common problems. You have partitioned it like the smaller panes in a large window. Now you will learn how to create very granular windows, much like stained glass, with the use of frames.

In this chapter, you will learn how framing, where it is supported, is so important for the accuracy of the results. The frame is also important for performance, but ...

Get Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.