Parameters
- PARTITION
Specifies that the query result set should be partitioned into one or more groups based on one or more expressions (expr).
- ORDER BY
Specifes how data is to be ordered within a partition.
- position
Specifies that the partition should be ordered according to the expression in this relative position in the expression list.
- c_alias
Specifies that the partition should be ordered according to the column identified by this alias.
- ROWS
Specifies that a window is defined in terms of physical rows.
- RANGE
Specifies that a window is defined in terms of a logical offset.
- BETWEEN
Specifies that a starting and ending point for a window will be defined.
- UNBOUNDED PRECEDING
Specifies that the window ends at the last row of the query.
- UNBOUNDED FOLLOWING
Specifies that the window starts at the first row of the query.
- CURRENT ROW
Specifies that the window begins at the current row or value, depending on whether ROWS or RANGE was specified.
- value_expr
Resolves to a number representing a physical offset if ROWS is specified or to a number representing a logical offset if RANGE is specified.
Common keywords and clauses: ASC, DESC, NULLS FIRST, NULLS LAST.