sql rank() vs dens_rank()

The RANK()  function is a window function that is used to assign a rank to each row in the partition of a result set.