Multiple choice

Which of the following statements is used for eliminating duplicating data in the row 'name' of 'class' table in a SELECT clause?

  1. SELECT UNIQUE name from class.

  2. SELECT name UNIQUE from class;

  3. SELECT DISTINCT name from class.

  4. SELECT name DISTINCT from name.

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

DISTINCT statement is used for eliminating duplicate data in the row.