From the output, you can see a gap within the rank perform output inside a partition. We don't have any gap inside the DENSE_RANK purpose. By default, it sorts the information in ascending order and commences assigning ranks for each row. In the above mentioned screenshot, we get ROW number https://www.rarabet.com