The UNION operator is used to combine the result-set of two or more SELECT statements when
each SELECT statement within the UNION has the same number of columns
The columns have similar data types
the columns in each SELECT statement are in same order.
None