|
|
|
| SQL - Structured Query Language |
Union OperatorUNION 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 |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR