SQL

Window Function

English

Overview

A function that attaches a per-group aggregate value to each row without collapsing them.

Details

A family of functions using the OVER clause that compute values such as rank, running totals, or moving averages within a group, without collapsing the rows.

More Database terms