Returns the percentile rank for the current row in the partition. With this function, the set of values (6, 9, 9, 14) would be ranked (4, 3, 3, 1).įor information on different ranking options, see Rank calculation. Use the optional 'asc' | 'desc' argument to specify ascending or descending order. Identical values are assigned an identical rank. Returns the modified competition rank for the current row in the partition. With this function, the set of values (6, 9, 9, 14) would be ranked (3, 2, 2, 1).įor information on different ranking options, see Rank calculation. Identical values are assigned an identical rank, but no gaps are inserted into the number sequence. Returns the dense rank for the current row in the partition. The remaining columns show the effect of each rank function on the set of age values, always assuming the default order (ascending or descending) for the function. The data set contains information on 14 students (StudentA through StudentN) the Age column shows the current age of each student (all students are between 17 and 20 years of age). The following image shows the effect of the various ranking functions (RANK, RANK_DENSE, RANK_MODIFIED, RANK_PERCENTILE, and RANK_UNIQUE) on a set of values. They are not numbered and they do not count against the total number of records in percentile rank calculations.įor information on different ranking options, see Rank calculation.

With this function, the set of values (6, 9, 9, 14) would be ranked (4, 2, 2, 1).

Returns the standard competition rank for the current row in the partition.

Tabular list example