While in the output, you are able to see a spot inside the rank function output inside a partition. We do not need any hole in the DENSE_RANK operate. By default, it sorts the info in ascending purchase and starts off assigning ranks for each row. In the above screenshot, https://www.rarabet.com