Thursday, February 14, 2019

RANK

Purpose: RANK calculates the rank of a value in a group of values. The return type is NUMBER
Rows with equal values for the ranking criteria receive the same rank. Oracle Database
then adds the number of tied rows to the tied rank to calculate the next rank.
Therefore, the ranks may not be consecutive numbers. This function is useful for top-N
and bottom-N reporting.

No comments:

Post a Comment