Zend
200-530 · Question #440
You want to retrieve all the data from any given table. You also want to ensure that no duplicate values are displayed. Which of the following SQL statements will you use to accomplish the task?
The correct answer is B. SELECT...DISTINCT. See the full explanation below for the reasoning.
Question
You want to retrieve all the data from any given table. You also want to ensure that no duplicate values are displayed. Which of the following SQL statements will you use to accomplish the task?
Options
- ASELECT...WHERE
- BSELECT...DISTINCT
- CSELECT...ALL
- DSELECT...TOP
How the community answered
(42 responses)- A12% (5)
- B79% (33)
- C2% (1)
- D7% (3)
Community Discussion
No community discussion yet for this question.