Inside the output, it is possible to see a gap during the rank purpose output inside a partition. We do not need any gap in the DENSE_RANK functionality. Want to discover what SQL window features are, when You need to use them, and why they are useful? This informative article https://bloglabs360.com