Which type of merge statement only combines rows that exist in two result sets?
A)UNION
B)EXCEPT
C)INTERSECT
D)JOIN

Name: Which type of merge statement only combines rows that exist in two result sets? A)UNION B)EXCEPT C)INTERSECT D)JOIN
Brand: Quizplus
Rating: 4.7 (38 reviews)

Question

Quizplus · Accepted Answer

The INTERSECT statement only combines rows that exist in both result sets. UNION combines all rows from both result sets, EXCEPT returns only rows from the first result set that are not in the second, and JOIN combines rows based on a specified condition.

Which Type of Merge Statement Only Combines Rows That Exist