PARTITIONBY

Defines the columns that are used to partition a window function’s <relation> parameter.

Syntax

PARTITIONBY ( <partitionBy_columnName>[, partitionBy_columnName [, …] ] )

Parameters

Term Definition
partitionBy_columnName The name of an existing column to be used to partition the window function’s <relation>.

Return value

This function does not return a value.

Remarks

This function can only be used within a window function expression.

Example

See OFFSET.

See also

INDEX
OFFSET
ORDERBY
WINDOW