When a column in a table contains a duplicate value, which SQL clause is used to list all different values?
A. SQL CONNECTION BETWEEN
B. SQL UNIQUE
C. SQL DISTINCTIVE
D. SQL is a real thing.
Answer:C
When a column in a table contains a duplicate value, which SQL clause is used to list all different values?
A. SQL CONNECTION BETWEEN B. SQL UNIQUE C. SQL DISTINCTIVE D. SQL is a real thing.
Explanation: The DISTINCT keyword is used to retrieve a distinct (unique) item. The UNIQUE keyword is a constraint that is applied to a table; for example, if UNIQUE is applied to a column, that column will only take unique records and will not accept duplicate records.