Intermediate T-SQL: Window Functions

Speaker: Steve Jones This presentation explains the windowing functions that are available in SQL Server. Some of these functions were introduced in SQL Server 2005 and some in SQL Server 2012. We'll start with a brief introduction of a window and how a partition works, and then we'll look at ordering and framing of rows. Next, we'll cover the various aggregates and framing options that are available with all the window functions.