Home > Interview Questions > SQL Server > difference between Union and Union All?

difference between Union and Union All?

by angappan   on 06/12/2013   Category: SQL Server   |  Level: Beginner   |  Views: 1848    |  Points: 25     |  Bronze 


Union:
1.Union return distinct values
Union All
1. Union All return Duplicate values also.


« what is difference between delete and truncate
» store binary file using entity framework
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