Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 70 of 79

MySQL SQL Revision Tour — Question 13

Back to all questions
13
Question

Question 13

In SQL, which command is used to SELECT only one copy of each set of duplicable rows ?

  1. SELECT DISTINCT
  2. SELECT UNIQUE
  3. SELECT DIFFERENT
  4. All of the above
Answer

SELECT DISTINCT

Reason — The SELECT DISTINCT statement is used in SQL to return only unique (distinct) values within the result set. It removes duplicate records, ensuring that each row in the result set is unique.