Skip to Main Content
T-SQL Window Functions: For data analysis and beyond, 2nd Edition
book

T-SQL Window Functions: For data analysis and beyond, 2nd Edition

by Itzik Ben-Gan
November 2019
Intermediate to advanced content levelIntermediate to advanced
352 pages
12h 27m
English
Microsoft Press
Content preview from T-SQL Window Functions: For data analysis and beyond, 2nd Edition

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL for Data Analysis

SQL for Data Analysis

Cathy Tanimura

Publisher Resources

ISBN: 9780135861554