Multiple choice technology testing

The SQL command used to avoid the selection of duplicate rows is

  1. UNIQUE

  2. DISTINCT

  3. EXCLUSIVE

  4. DISCRETE

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

DISTINCT is the SQL keyword that eliminates duplicate rows from query results. When added to a SELECT statement, it ensures each row returned is unique. Options like UNIQUE, EXCLUSIVE, and DISCRETE are not valid SQL keywords for this purpose.