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.