From the output, you may see a gap during the rank perform output inside of a partition. We do not need any hole within the DENSE_RANK function. This function was not out there inside the no cost version but this quality Edition is released with this function which helps to https://bloglabs360.com