Options on Window Functions

Steve Stedman takes us through the options available in SQL Server to define a window in a window function:

ROWS PRECEDING, FOLLOWING, UNBOUNDED, refers to the current row and those before or after based on preceding or following.
RANGE PRECEDING, FOLLOWING, UNBOUNDED, means all values in the current range and those before or after.

Read on to see how to use these.