Expand description

Window frame module

The frame-spec determines which output rows are read by an aggregate window function. The frame-spec consists of four parts:

  • A frame type - either ROWS, RANGE or GROUPS,
  • A starting frame boundary,
  • An ending frame boundary,
  • An EXCLUDE clause.

Structs§

  • The frame specification determines which output rows are read by an aggregate window function. The ending frame boundary can be omitted if the BETWEEN and AND keywords that surround the starting frame boundary are also omitted, in which case the ending frame boundary defaults to CURRENT ROW.

Enums§

  • There are five ways to describe starting and ending frame boundaries:
  • There are three frame types: ROWS, GROUPS, and RANGE. The frame type determines how the starting and ending boundaries of the frame are measured.

Functions§