Expert T-SQL Window Functions in SQL Server 2019
Kathi Kellenberger, Clayton Groom, Ed Pollack · Apress eBooks · 2019
This book turns you into an expert user of window functions who can solve T-SQL queries. Master the OVER clause, the framing clause, and functions such as LAG and LEAD, RANK, and more. Replace slow cursors and self-joins with queries that are easy to write and perform better.