Multiple choice technology databases

Duplicate values are eliminated by which keyword

  1. Duplicate

  2. Distinct

  3. Remove

  4. Delete

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

DISTINCT keyword in SELECT statement removes duplicate rows from the result set, returning only unique values. Options A, C, and D are not valid SQL keywords for eliminating duplicates.