Zend
ZF-100-500 · Question #153
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…
The correct answer is B. 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 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?
Options
- ASELECT Product_No, Prod_Category
- BSELECT DISTINCT Product_No, Prod_Category
- CSELECT Product_No, Prod_Category
- DSELECT Product_No, Prod_Category
How the community answered
(63 responses)- A5% (3)
- B81% (51)
- C11% (7)
- D3% (2)
Community Discussion
No community discussion yet for this question.