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 C. SELECT...DISTINCT. Zend ZF-100-500 Exam

Shells, Scripting and Data Management

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...TOP
BSELECT...WHERE
CSELECT...DISTINCT
DSELECT...ALL

How the community answered

(22 responses)

A
14% (3)
B
5% (1)
C
77% (17)
D
5% (1)

Explanation

Zend ZF-100-500 Exam

Topics

#SQL#SELECT DISTINCT#deduplication#data retrieval

Community Discussion

No community discussion yet for this question.

Full ZF-100-500 Practice