Last Updated on: 1st July 2024, 02:06 pm
The RANKX Syntax
The basic syntax of the RANKX function is:
RANKX(
,
[, [, [, ]]])
Where:
is the table or table expression to be ranked.
is the expression to be evaluated for ranking.
(optional) is the row to be ranked. If omitted, the current row is used.
(optional) specifies the ranking order (0 for descending, 1 for ascending).
(optional) specifies how to handle ties (0 for dense ranking, 1 for skip ranking).
Share this post on social! 
