The UNION operator returns results from both queries after eliminating duplications.
The UNION ALL operator returns results from both queries, including all duplications.
The INTERSECT operator returns rows that are common to both queries.
The MINUS operator returns rows in the first query that are not present in the second query.
•
No comments:
Post a Comment