Zend
ZF-100-500 · Question #50
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 d oes not want to…
The correct answer is A. SELECT DISTINCT Product_ No, Prod_Category. See the full explanation below for the reasoning.
Question
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 d oes not want to display any duplicate row in the report. Which of the following SELECT statements will Martin use to create the report?
Options
- ASELECT DISTINCT Product_ No, Prod_Category
- BSELECT Product_No, Prod_Category
- CSELECT Product_No, Prod_Category
- DSELECT Product_No, Prod_Category
How the community answered
(41 responses)- A76% (31)
- B12% (5)
- C5% (2)
- D7% (3)
Community Discussion
No community discussion yet for this question.