Background of Window Functions
A Glimpse of Solutions Using Window Functions
Elements of Window Functions
Query Elements Supporting Window Functions
Potential for Additional Filters
Reuse of Window Definitions
Summary
Chapter 2 A Detailed Look at Window Functions
Window Aggregate Functions
Ranking Functions
Distribution Functions
Offset Functions
Summary
Chapter 3 Ordered Set Functions
Hypothetical Set Functions
Inverse Distribution Functions
Offset Functions
String Concatenation
Summary.
Chapter 4 Optimization of Window Functions
Sample Data
Indexing Guidelines
Ranking Functions
Improved Parallelism with APPLY
Aggregate and Offset Functions
Distribution Functions
Summary
Chapter 5 T-SQL Solutions Using Window Functions
Virtual Auxiliary Table of Numbers
Sequences of Date and Time Values
Sequences of Keys
Paging
Removing Duplicates
Pivoting
TOP N per Group
Mode
Running Totals
Max Concurrent Intervals
Packing Intervals
Gaps and Islands
Median
Conditional Aggregate
Sorting Hierarchies
Summary
Index