Home > Interview Questions > SQL Server > What is the difference between UNION ALL and UNION in SQL server?

What is the difference between UNION ALL and UNION in SQL server?

by Thamil   on 22/12/2011   Category: SQL Server   |  Level: Beginner   |  Views: 1393    |  Points: 25     |  Gold 


UNION ALL is used to select all the records from the two tables and the selected column of both table should be same data type but Union is used to select the distinct records from both tables.


« Where is viewste informations stored?
» Is it possible to insert NULL into unique column?
Post Question  |  Question Home

Recent Posts

User Responses


No response found, be the first to review this question.

Submit feedback about this code snippet

Please sign in to post feedback

Latest Posts