Which of the following statements eliminates all but one of each set of duplicate rows in the final result table?

  1. SELECT UNIQUE * FROM t1

  2. SELECT DISTINCT * FROM t1

  3. SELECT UNIQUE (*) FROM t1

  4. SELECT DISTINCT (*) FROM t1

  5. None of above


Correct Option: B

Find more quizzes: