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 SQL DISTINCT clause eliminates duplicate rows from query results, ensuring that each returned record is unique. It filters out redundant entries to present a set of distinct records.

Example:

SELECT DISTINCT column_name
FROM table_name;
  

This query retrieves only the unique values present in the specified column. The functionalities of DESCRIBE, UNIQUE, and NULL do not achieve this outcome.