SQL SET OPERATORS: UNION, INTERSECT & MINUS

It is used to combine the results of two or more select statements. SET OPERATOR TYPES : Union Union All Intersect Minus 1. UNION Union operators return only unique values from the tables. --