Post
Ask Question

Ankur Jain
What the difference between UNION and UNIONALL?
By Ankur Jain in SQL Server on Aug 18 2014
  • Sreekanth Reddy
    Jul, 2015 11

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

    • 0
  • jeet gupta
    Feb, 2015 16

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

    • 0
  • Gokul Rathod
    Nov, 2014 25

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

    • 0
  • Ankur Jain
    Aug, 2014 18

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

    • 0


Most Popular Job Functions

View All

MOST LIKED QUESTIONS