Which Transact-SQL statement should you use?

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 Transact-SQL statement should you use?

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 Transact-SQL statement should you use?

A.
NTILE(1)

B.
NTILE(4)

C.
NTILE(25)

D.
NTILE(100)



Leave a Reply 0

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