Detailed explanation and options for the selected question.
Which SQL operator is used to combine the results of multiple SELECT statements?
A.
UNION
B.
JOIN
C.
INTERSECT
D.
MERGE
Explanation:
UNION combines results of multiple SELECT statements and removes duplicates by default. JOIN links tables, INTERSECT finds common rows, and MERGE is invalid.