Inside the output, it is possible to see a spot during the rank purpose output within a partition. We don't have any gap from the DENSE_RANK functionality. In the output, you'll be able to see we have the exact rank for the two Lily and Isabella who scored 70 marks. https://www.rarabet.com