Which operator do you use to return all of the rows from one query except rows are returned in a second query?

You use the MINUS operator to return all rows from one query except
where duplicate rows are found in a second query. The UNION operator
returns all rows from both queries minus duplicates. The UNION ALL
operator returns all rows from both queries including duplicates.
The INTERSECT operator returns only those rows that exist in both queries.

No comments:

Post a Comment