SQL - Structured Query Language

Union Operator



UNION operator combines the results of two or more queries into a single result set that includes all records that belong to all queries in the UNION. The number and the order of the columns must be the same in all UNION queries and then data types must be compatible. UNION operator ignores duplicate records. The following UNION query is used to combine Sales Year 01 and 02 records.

-- Example 39 --

 

SELECT * FROM Sales_Year_01

UNION

SELECT * FROM Sales_Year_02


Query Output Screen



* * * * *


Email Your Comment To AUTHOR