Which query will provide the required result?

You want to display 5 percent of the rows from the sales table for products with the lowest
AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD
even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

You want to display 5 percent of the rows from the sales table for products with the lowest
AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD
even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

A.
Option A

B.
Option B

C.
Option C

D.
Option D



Leave a Reply 2

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


Alex

Alex

Answer D, you can’t use with ties and only at the same time.