The ____ set operator returns one query less the other,similar to a left outer join where only distinct rows in the first query are returned.
A) UNION ALL
B) INTERSECT
C) MINUS
D) DISTINCT

Question

Quizplus · Accepted Answer

The MINUS set operator returns only distinct rows from the first query that are not in the second query. This is similar to a left outer join where only the rows from the first table that do not have a match in the second table are returned. The UNION ALL operator combines the results of two queries, including duplicates. The INTERSECT operator returns only the distinct rows that are common to both queries. The DISTINCT keyword is used to remove duplicates from the result set of a single query.

The ____ Set Operator Returns One Query Less the Other,similar