Which TransactSQL statement should you use?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *