How To Use UNION Operator In SQL
In this article, we will learn how to use the UNION operator in SQL.
To combine the result-set of multiple SELECT statements, the UNION operator is used.
Within UNION each SELECT statement must have the same number of columns.
The columns must also have similar data types.
The columns must also be in the same order in each SELECT statement.