The RANK() function is one of the ranking functions in T-SQL used to assign a rank to each row within a partition of a result...