Martin works as a Database Administrator for MTech Inc.

Zend ZF-100-500 Question Answer

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?

SELECT Product_No, Prod_Category

FROM Products;

SELECT DISTINCT Product_No, Prod_Category

FROM Products;

SELECT Product_No, Prod_Category

FROM Products

GROUP BY Product_No;

SELECT Product_No, Prod_Category

FROM Products

GROUP BY Product_No ORDER BY Product_No;