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 Transact-SQL statement should you use?
A. ROW_NUMBER
B. DENSE_RANK
C. RANK
D. NTILE(10)