Discuss Forum
1. To remove duplicate rows from the results of an SQL SELECT statement , the __ qualifier specified must be included.
- A. ONLY
- B. ONLY
- C. ONLY
- D. ONLY
Answer: Option B
Explanation:
The SQL DISTINCT keyword is used in conjunction with the SELECT statement to eliminate all the duplicate records and fetching only unique records. There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only those unique records instead of fetching duplicate records. Syntax The basic syntax of DISTINCT keyword to eliminate the duplicate records is as follows − SELECT DISTINCT column1, column2,.....columnN FROM table_name WHERE [condition]
Post your comments here: