The RANK and DENSE_RANK functions are slightly different from each other as well as the ROW_NUMBER function: RANK numbers are skipped so there may be a gap in rankings, and may not be unique. DENSE_RANK numbers are not skipped so there will not be a gap in rankings, and may not be unique.