Fill in the blank:
The SELECT statement when combined with __________ clause,
returns records without repetition.
(a)
DESCRIBE
(b)
UNIQUE
(c)
DISTINCT
(d)
NULL
Answer:
The SELECT statement when combined with DISTINCT clause, returns records without repetition.
Syntax:
SELECT
DISTINCT
column1
,
column2, ...
FROM
table_name
;
So, the correct answer is (c).