SQL Window Functions

SQL window functions are SQL functions applied to row sets associated with rows:

    window-function over (row-set-definition)