When performing set operations on two data sets, the following guidelines must apply:
- Both data sets must have the same number of columns
- The data types of each column across the two data sets must be the same (or the server must be able to convert one to the other).
The SQL language includes three set operators:
union,intersect,except
union all operator doesn’t remove duplicates
except
