PrepAway - Latest Free Exam Questions & Answers

Which set operators can be used to produce a result data set that contains only records that are not found in

Given the following queries:
SELECT c1 FROM tab1;

SELECT c1 FROM tab2;
Which set operators can be used to produce a result data set that contains only records that are
not found in the result data set produced by each query after duplicate rows have been
eliminated?

PrepAway - Latest Free Exam Questions & Answers

A.
UNION

B.
INTERSECT

C.
EXCEPT

D.
MERGE

Explanation:


Leave a Reply