To return only unique (non-duplicate) values from a specific column in a…
2026
To return only unique (non-duplicate) values from a specific column in a query, which keyword must be used?
Answer: B. DISTINCT — To retrieve only unique (non-duplicate) values from a specific column in an SQL query, the keyword DISTINCT must be used. The syntax is SELECT DISTINCT…
- A.
UNIQUE
- B.
DISTINCT
- C.
DIFFERENT
- D.
SINGULAR
Attempted by 1605 students.
Show answer & explanation
Correct answer: B
To retrieve only unique (non-duplicate) values from a specific column in an SQL query, the keyword DISTINCT must be used. The syntax is SELECT DISTINCT column_name FROM table_name.
Loading lesson…