Querying Databases Using Transact-SQL/

...

/

Window Functions

Window Functions

Learn how to perform aggregation while retaining row-level detail.

We'll cover the following...

Let’s consider the following table, ActionPoints, which tracks the points earned during a game.

In the table above, the column names are:

  • ActionId: A unique ID that is given to a performed game action.
  • Player: A player who performed the action.
  • Points: Points earned for the given action.

Limitations of aggregate functions

...