From the output, you may see a niche in the rank purpose output inside a partition. We would not have any gap from the DENSE_RANK purpose. Britannica Dictionary definition of RANK one [much more rank; most rank] : using a solid, unpleasant scent the rank SQL ranking features make working https://bloglabs360.com