Window Functions

Window functions are functions applied over a subset (known as a window) of the rows returned by a SELECT query and describes the following:

LAG LEAD ROW_NUMBER RANK FIRST_VALUE LAST_VALUE NTH_VALUE DENSE_RANK PERCENT_RANK CUME_DIST NTILE

For more information, see Window Functions in the SQL Syntax Features section.