A. To count the total number of rows in a result set
B. To assign a unique number to each row within a partition of a result set
C. To retrieve the row with the maximum value in a column
D. To calculate the average value of a column

Solution

B. To assign a unique number to each row within a partition of a result set