rank with partition by

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