Chapter 2. A Detailed Look at Window Functions
This chapter looks at the various types of window functions, getting into the details of each. Still, the focus in this chapter is on the logical aspects of the functions. Optimization will be covered separately in Chapter 4.
The main reason for separating the discussion of the two layers into different chapters is that standard SQL deals only with the logical layer. And because Microsoft SQL Server implements the functions based on the standard, the coverage of the logical aspects of the functions in this book could be interesting for readers who use database platforms other than SQL Server as well. Chapter 4 focuses on the optimization of the functions—namely, the physical layer, which is very platform-specific—and ...
Get Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions 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.
