Window Functions

Have you heard about window functions but never learned how to use them? Learn how they work and how to take full advantage of them.

This tutorial shows you how to use the ROW_NUMBER() to assign a sequential number to each row in a query result set.

This article explains the use of Aggregate, Raking and Value Windows Functions in SQL Server.

This article covers the SQL PARTITION BY clause and, in particular, the difference with GROUP BY in a select statement.

Window functions can only appear in SELECT and ORDER BY but not in WHERE clauses. The reason is the logical order in which SQL queries are processed.