SQL SERVER: ROW_NUMBER () vs. DENSE_RANK ()

ROW_NUMBER() is well known to return sequential number of rows with in a partition of a result set. DENSE_RANK()provide you facility to get distinct rank number for partition in a result set. When we need it and how to use it.