CHAPTER 2
A Detailed Look at Window Functions
This chapter looks at the various types of window functions and gets into the details of each. Still, this chapter focuses on the logical aspects of the functions. Optimization will be covered separately in Chapter 5, “Optimization of Window Functions.”
The main reason for separating the discussion of the two layers into different chapters is that the SQL standard 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 5 focuses on the optimization of the functions—namely, the ...
Get T-SQL Window Functions: For data analysis and beyond, 2nd 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.