While in the output, you'll be able to see a gap in the rank functionality output in a partition. We do not have any gap inside the DENSE_RANK purpose. This element was not readily available from the free of charge Edition but this quality Variation is launched using this element https://bloglabs360.com