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

Explanation:

Show Hint

Leave a Reply 3

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

Mr. T

Mr. T

Yes, D
The answer must include “WITH TIES” and there is no “ROWS ONLY WITH TIES” and no “ROWS WITH TIES ONLY”.

Reply

mickael

mickael

agree with mr T

Reply