Write queries that use window functions
Learn how to use window functions in Transact-SQL.
Learning objectives
After completing this module, you’ll be able to:
Describe window functions.
Use the OVER clause.
Use RANK, AGGREGATE, and OFFSET functions.
Add
Prerequisites
Before starting this module, you should have experience of using Transact-SQL queries to retrieve and filter data from a table in a database.