Using SQL ranking function to generate 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.