SQL Server Windows Function

Name	Description
CUME_DIST	Calculate the cumulative distribution of a value in a set of values
DENSE_RANK	Assign a rank value to each row within a partition of a result, with no gaps in rank values.
FIRST_VALUE	Get the value of the first row in an ordered partition of a result set.
LAG	Provide access to a row at a given physical offset that comes before the current row.
LAST_VALUE	Get the value of the last row in an ordered partition of a result set.
LEAD	Provide access to a row at a given physical offset that follows the current row.
NTILE	Distribute rows of an ordered partition into a number of groups or buckets
PERCENT_RANK	Calculate the percent rank of a value in a set of values.
RANK	Assign a rank value to each row within a partition of a result set
ROW_NUMBER	Assign a unique sequential integer to rows within a partition of a result set, the first row starts from 1.