Reference Guide > TDV Support for SQL Functions > Analytical Functions > RANK
 
RANK
RANK calculates the rank of a value in a group of values.
Syntax
RANK () OVER ( [ PARTITION BY expression [, ...] ]
ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
Remarks
PARTITION BY is optional.
ORDER BY is required.
The window clause is not allowed.