4
Reply

What the difference between UNION and UNIONALL?

Ankur Jain

Ankur Jain

Aug 18, 2014
1.2k
0

    Union--> can retrieve the data from multiple tables(of same no of columns and data type) without duplicates.UnionAll-->viceversa to union

    Srikanth Reddy
    July 11, 2015
    0

    you can go through this link.http://www.codeproject.com/Articles/716224/SQL-Server-What-exactly-are-UNION-and-UNION-All

    jeet gupta
    February 16, 2015
    0

    UNION - Only take single entry of row if available in both table in UnionAll is give duplicate entry also

    Gokul Rathod
    November 25, 2014
    0

    Union will remove the duplicate rows from the result set while Union all does'nt.

    Ankur Jain
    August 18, 2014
    0