November 2019
Intermediate to advanced
352 pages
12h 27m
English
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 ...