Martin works as a Database Administrator for MTech Inc.

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