SQL DENSE_RANK Function

The SQL Server DENSE_RANK Function is one of the Ranking functions. The SQL DENSE_RANK function will assign the rank number to each record present in a partition without skipping the rank numbers. If the function encounters two equal values in the same partition, it will assign the same rank number to both values. In this … Read more