You need to write a query that uses a ranking function that returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
Which TransactSQL statement should you use?
A.
RANK
B.
NTILE(10)
C.
DENSE_RANK
D.
ROW_NUMBER