2
Reply
Reply

What is the difference between UNION and UNION ALL?

Shalini Juneja

Shalini Juneja
May 06, 2011
4.2k
0
    vijay kumar singh

    Union add two or more table data without repetition

    While Union all add two or more data with all repetitive data

    vijay kumar singh
    May 09, 2011
    0
    Shalini Juneja

    1. UNION The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type. With UNION, only distinct values are selected.
    2. UNION ALL The UNION ALL command is equal to the UNION command, except that UNION ALL selects all values.
    The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table.

    Shalini Juneja
    May 06, 2011
    0