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

The DISTINCT keyword is used in a SELECT statement to eliminate duplicate rows from the result set. For example, SELECT DISTINCT department FROM employees returns each department only once, regardless of how many employees belong to it.

Keep practicing — related questions