Intro

Aggregate Functions and Group By

Window Function Example

Visualization of Window Function

Using PARTITION

Aggregate Functions

Rank

ORDER BY Clause

Running the query

Conclusion

Definition of Window Functions

Types of Window Functions

Window Functions Syntax

Group By vs Window Functions

Over Clause, Partition By, Order By..

Implementation With SSMS

What the OVER clause does

The WINDOWS clause

The PARTITION BY clause

The ORDER BY clause

Define a sliding window with ORDER BY 1 PRECEDING AND 1 FOLLOWING

Remove rows from the window with EXCLUDE

Combining PARTITION BY with ORDER BY

Get values from the previous or next rows with LAG/LEAD

How sorting using non-unique values affects the results

Using window functions to avoid self-joins

Using window functions to calculate running totals or moving averages

Using window functions to do inter-row calculations

Example query to avoid repeated table access

Recap

Using RANK/ROW_NUMBER/DENSE_RANK with PARTITION BY