What the difference between UNION and UNIONALL?

Ankur Jain

10y

1.2k

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

10y

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

10y