Martin works as a Database Administrator for MTech Inc. He designs a database that has a table
named Products. He wants to create a report listing different product categories. He does not want
to display any duplicate row in the report. Which o f the following SELECT statements will Martin
use to create the report?

A.
SELECT Product_No, Prod_Category
FROM Products;

B.
SELECT DISTINCT Product_No, Prod_Category
FROM Products;

C.
SELECT Product_No, Prod_Category
FROM Products
GROUP BY Product_No;

D.
SELECT Product_No, Prod_Category
FROM Products
GROUP BY Product_No ORDER BY Product_No;