From the output, you may see a niche in the rank purpose output in a partition. We would not have any hole inside the DENSE_RANK functionality. By default, it kinds the info in ascending buy and starts assigning ranks for every row. In the above mentioned screenshot, we get ROW https://www.rarabet.com