sql rank

SQL Server DENSE_RANK()

The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.

The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.