Multiple choice database

You run a SELECT statement, and multiple duplicates of values are retrieved. What keyword can you use to retrieve only the non duplicate data?

  1. DUBPLICATE

  2. INDIVIDUAL

  3. SEPARATE

  4. DISTINCT

  5. INDEX

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The DISTINCT keyword in SQL is used within a SELECT statement to filter out duplicate rows from the result set, returning only unique values. Keywords like 'INDIVIDUAL' or 'SEPARATE' are not valid SQL syntax for this purpose.