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 of 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;

Explanation: