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:
The FETCH statement must include WITH TIES.
Incorrect:
Not B: You cannot use ROWS WITH in a FETCH statement.