You need to write a query that allows you to rank total sales for each salesperson into four groups,
where the top 25 percent of results are in group 1, the next 25 percent are in group 2, the next 25
percent
are in group 3, and the lowest 25 percent are in group 4.
Which TransactSQL
statement should you use?
A.
NTILE(1)
B.
NTILE(4)
C.
NTILE(25)
D.
NTILE(100)