Multiple choice

The command used to select only one copy of each set of duplicable rows is called

  1. Select distinct

  2. Select unique

  3. Select different

  4. None of above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SELECT DISTINCT is the SQL command that eliminates duplicate rows from query results, returning only unique values. DISTINCT is a keyword that filters out repeated rows in the specified columns. SELECT UNIQUE and SELECT DIFFERENT are not valid SQL syntax.

Keep practicing — related questions