Skip to main content
returns the relative rank (i.e. percentile) of rows within a window partition. Syntax Alias: percentRank (case-sensitive)
The function always reads the whole partition; a window frame, if specified, is ignored. For more detail on window function syntax see: Window Functions - Syntax. Example
Query
Query
Response