In the output, it is possible to see a gap inside the rank function output inside a partition. We don't have any gap from the DENSE_RANK function. MoneySavingPro independently researches the solutions & services to carry you our tips. We may receive revenue whenever you simply click our hyperlinks - https://www.rarabet.com