RANK and DENSE_RANK

RANK() : function always returns sequential order for each record.DENSE_RANK() : It returns continuous order for each record. Read more