The statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.
A)UNION
B)UNION ALL
C)INTERSECT
D)MINUS

Question

Quizplus · Accepted Answer

The statement that combines rows from two queries and returns only the rows that appear in the first set but not in the second is called MINUS or EXCEPT in some databases. This operation is not supported by all databases, but it is equivalent to the LEFT OUTER JOIN with a NULL check. The MINUS statement is the opposite of the UNION statement, which combines rows from two queries and returns only the distinct rows from both sets. INTERSECT combines only the rows that appear in both sets, and UNION ALL returns all rows from both sets, including duplicates.

The Statement in SQL Combines Rows from Two Queries and Returns