The ____ query combines rows from two queries and excludes duplicates.
A) UNION
B) UNION ALL
C) INTERSECT
D) MINUS

Question

Quizplus · Accepted Answer

The UNION query combines the result sets of two SELECT statements into a single result set while eliminating duplicate rows. UNION ALL also combines two SELECT statements but does not filter out the duplicates. INTERSECT returns all the common rows between two SELECT statements while MINUS returns the rows present in the first SELECT statement but not in the second SELECT statement. Therefore, the best choice for the given requirement is UNION.

The ____ Query Combines Rows from Two Queries and Excludes