Question

The SELECT statement when combined with \(\_\_\_\_\_\_\) clause, returns records without repetition.
 

• A. DISTINCT
• B. DESCRIBE
• C. UNIQUE
• D. NULL

Hint:

Use DISTINCT in SQL queries to remove duplicate rows from the result set.

Answer 1

The Correct Option is A

The DISTINCT clause in SQL is used to ensure that the results of a query do not contain duplicate rows. It filters out duplicate records from the output and ensures that each row in the result set is unique.

Example:

SELECT DISTINCT column_name 
FROM table_name;
  

This will return only unique values from the specified column. None of the other options (DESCRIBE, UNIQUE, or NULL) perform this functionality.