UNION returns all distinct rows selected by either query - SQL Operations

Q.  Which of the following returns all distinct rows selected by either query?
- Published on 19 Oct 15

a. INTERSECT
b. MINUS
c. UNION
d. UNION ALL

ANSWER: UNION
 
The union operator is used to combine result set of two or more select statements. It avoids duplication.

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲