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