Home »
MCQs »
SQL MCQs »
SQL Functions MCQs
From the set of results, in order to remove the duplicate columns, ____ Clause is used
19. From the set of results, in order to remove the duplicate columns, ____ Clause is used.
- DUPLICATE
- DISTINCT
- REMOVE
- DROP
Answer: B) DISTINCT
Explanation:
From the set of results, in order to remove the duplicate columns, DISTINCT Clause is used. It is used in conjunction with SELECT keyword.