RANK Function Syntax (Teradata) | Teradata Vantage - RANK Function Syntax (Teradata) - Analytics Database - Teradata Vantage

RANK ( sort_spec [,...] )

Syntax Elements

sort_spec

sort_expression [ ASC | DESC ]

sort_expression

A literal or column expression or comma-separated list of literal or column expressions to be used to sort the values.

The expression cannot contain any ordered analytical or aggregate functions.

ASC

Ascending sort order.

DESC

Descending sort order.