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.