Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Union vs Intersect SQL

UNION operation
The UNION operation combines the results of two subqueries into a single result that comprises the rows that are returned by both queries.
INTERSECT operation
The INTERSECT operation combines the results of two queries into a single result that comprises all the rows common to both queries. Whereas a UNION operation is a logical OR, INTERSECT is a logical AND.
Source by www.ibm.com #
 
PREVIOUS NEXT
Tagged: #Union #Intersect #SQL
ADD COMMENT
Topic
Name
6+9 =