From the output, you could see a gap during the rank functionality output within a partition. We do not need any hole from the DENSE_RANK function. Britannica Dictionary definition of RANK one [extra rank; most rank] : getting a strong, uncomfortable scent the rank Woolacombe Seashore in North Devon is https://bloglabs360.com