O'Reilly logo

Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required