BD Merit - Freelancing, BCS, Bank, Primary, Admission, NTRCA

1 . To remove duplicate rows from the results of an SQL SELECT statement , the __ qualifier specified must be included.

A. ONLY
B. DISTINCT
C. UNIQUE
D. SINGLE

View Answer

Discuss in Forum

Workspace

Report

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]

Sonali- Rupali- Bangladesh Krishi- Rajshahi krishi unnayn-Investment Corporation of Bangladesh | 30.11.2018

কোর্স ক্যাটাগরি

প্রয়োজনীয় লিঙ্ক