PARTITIONBY
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
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 | (Optional) The name of an existing column to be used to partition the window function’s <relation>. RELATED() may also be used to refer to a column in a table related to <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.
Related content
Understanding ORDERBY, PARTITIONBY, and MATCHBY functions
INDEX
OFFSET
ORDERBY
MATCHBY
WINDOW
RANK
ROWNUMBER
Tagasiside
https://aka.ms/ContentUserFeedback.
Varsti tulekul: 2024. aasta jooksul tühistame GitHubi probleemide funktsiooni sisutagasiside mehhanismina ja asendame selle uue tagasisidesüsteemiga. Lisateabe saamiseks vtEsita ja vaata tagasisidet