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?
- A.
UNIQUE
- B.
DISTINCT
- C.
DIFFERENT
- D.
SINGULAR
Attempted by 741 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.