A query that uses the ____ set operator joins the output of two unrelated queries into a single output result.
A)INTERSECT
B)DIFFERENCE
C)MERGE
D)UNION

Question

Quizplus · Accepted Answer

The UNION set operator is used to combine the results of two unrelated queries into a single result set. It returns only distinct values from both queries, eliminating duplicates. The INTERSECT operator returns only the common rows between the result sets of two queries. The DIFFERENCE operator returns the rows that are present in the first query but absent in the second query. There is no MERGE set operator in SQL.

A Query That Uses the ____ Set Operator Joins the Output