Book description
- Solve complex query problems without cumbersome self-joins that run slowly and are difficult to read
- Create sliding windows in a result set for computing such as running totals and moving averages
- Return aggregate and detail data simultaneously from the same SELECT statement
- Compute lag and lead and other values that access data from multiple rows in a result set
- Understand the OVER clause syntax and how to control the window
- Avoid framing errors that can lead to unexpected results
Table of contents
- Cover
- Front Matter
- 1. Looking Through the Window
- 2. Discovering Ranking Functions
- 3. Summarizing with Window Aggregates
- 4. Calculating Running and Moving Aggregates
- 5. Adding Frames to the Window
- 6. Taking a Peek at Another Row
- 7. Understanding Statistical Functions
- 8. Tuning for Better Performance
- 9. Hitting a Home Run with Gaps, Islands, and Streaks
- 10. Time Range Calculations
- 11. Time Trend Calculations
- Back Matter
Product information
- Title: Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
- Author(s):
- Release date: October 2019
- Publisher(s): Apress
- ISBN: 9781484251973
You might also like
book
T-SQL Querying
T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency …
book
Hands-On SQL Server 2019 Analysis Services
Get up to speed with the new features added to Microsoft SQL Server 2019 Analysis Services …
book
SQL Server 2019 Administration Inside Out
Conquer SQL Server 2019 administration–from the inside out Dive into SQL Server 2019 administration–and really put …
book
SQL Server Advanced Troubleshooting and Performance Tuning
This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft …