4
Reply

What the difference between UNION and UNIONALL?

Ankur Jain

Ankur Jain

11y
1.6k
0
Reply
    Union--> can retrieve the data from multiple tables(of same no of columns and data type) without duplicates.UnionAll-->viceversa to union
    you can go through this link.http://www.codeproject.com/Articles/716224/SQL-Server-What-exactly-are-UNION-and-UNION-All
    UNION - Only take single entry of row if available in both table in UnionAll is give duplicate entry also
    Union will remove the duplicate rows from the result set while Union all does'nt.