Wednesday, February 4, 2015

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.