Inside the output, it is possible to see a gap from the rank functionality output in a partition. We do not have any hole in the DENSE_RANK operate. Want to discover what SQL window capabilities are, when You should use them, and why They are really valuable? This short article https://bloglabs360.com