select rank in sql

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