Window function

A function evaluated over a partition of query rows while preserving one output row per input row.