UNION ALL Operator Assignment Help

Assignment Help: >> SET operators - UNION ALL Operator

UNION ALL Operator

An UNION ALL operator works the similar way as the UNION Operator. Only the difference is that this operator displays duplicate values also.

Example

SELECT * FROM x UNION ALL SELECT * FROM y
The output of this query looks like:

ITEMCODE    NAME


1                Powders
2                 Soaps
2                 Soaps
3                Creams
4                Pencils
4                  Pens

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd