Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries

© 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 Kellenberger¹ , Clayton Groom² and Ed Pollack³

(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 ...