Netezza Set Operators:UNION, MINUS and INTERSECT

You can use the Netezza set operators to combine similar data sets from two or more SELECT statements. Here the similar data set literally mean, the data type of the result set should also match, otherwise you have to explicitly type cast data when using Netezza set operators. Read: nzsql command and usage nzload command and usage Types of Netezza Set Operators Netezza supports the three types of set operators: UNION [DISTINCT] and UNION ALL INTERSECT [DISTINCT] EXCEPT [DISTINCT] or MINUS [DISTINCT] Netezza Set Operators Syntax: Below is the general…

Continue ReadingNetezza Set Operators:UNION, MINUS and INTERSECT
Comments Off on Netezza Set Operators:UNION, MINUS and INTERSECT