This function will assign the unique Id to each row of result. Please see the result in above image ... please see the below result As we can see Marks with value 70 is assigned the same rank 4 but ...

This article explains SQL window functions ROW_NUMBER, RANK, and DENSE_RANK. It provides examples and syntax for each function and explains how to handle ties and gaps in ranking. The article also ...

INCLUDE [sql ... fabricdw.md)] Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows.