Difference Between Row_Number, Rank, Dense_Rank

ROW_NUMBER():Returns rownumber of each row of result set.

 DENSE_RANK(): Returns the rank of rows within the partition of a result set, without any gaps in the ranking.

RANK(): Returns the rank of each row within the partition of a result set.