Simply put, RANK skips the amount of positions following records with the exact rank number. The ranking RANK_DENSE returns posture quantities from one to six since it doesn’t skip information With all the identical rank amount: Returns the rank of every row inside the partition of a result set. The https://rsac.org