Calculates the relative rank of a row within a group of rows in [!INCLUDE [ssnoversion](../../includes/ssnoversion-md.md)]. Use `PERCENT_RANK` to evaluate the ...
-- we use Rank() when we want to know the relative oder of particular rows relative to other rows. (such as 1, 2, 3, etc.) -- the ranking 1, 2, 3 will restart when it reaches to another unique group.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results