CHAPTER 4

Row-Pattern Recognition in SQL

This book is dedicated to using window functions in your T-SQL code. In large part, the book covers windowing and related analytical features that at the date of this writing have already been implemented in T-SQL. That’s what you would naturally expect from a book entitled “T-SQL Window Functions.” However, as you’ve already noticed, the book also exposes you to features that are part of the SQL standard but that have not yet been implemented in T-SQL. I find this coverage just as important. It raises awareness to what’s out there, and hopefully, it will motivate you, as part of the Microsoft data platform community, to ask Microsoft to improve SQL Server and Azure SQL Database by adding such features ...

Get T-SQL Window Functions: For data analysis and beyond, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.