Reference Guide > TDV Support for SQL Functions > Analytical Functions > PERCENT_RANK
 
PERCENT_RANK
PERCENT_RANK is similar to the CUME_DIST (cumulative distribution) function.
Syntax
PERCENT_RANK () OVER ( [ PARTITION BY expression [, ...] ]
ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
Remarks
The first row in any set has a PERCENT_RANK of 0.
The range of values returned by PERCENT_RANK is 0 to 1, inclusive.
PARTITION BY is optional.
ORDER BY is required.
The window clause is not allowed.