Types of SQL windows functions

> Aggregate functions (within a window frame)

• avg()

• count()

• max()

• min()

• sum()

> Ranking functions

• row_number()

• rank()

• dense_rank()

> Distribution functions

• percent_rank()

• cume_dist()

> Analytic functions

• lead()

• lag()

• ntile()

• first_value()

• last_value()

• nth_value()