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

Ads

 
 

Share on Google+Share on Google+

hemant kumar
What is the difference between UNION and UNION ALL in SQL?
1 Answer(s)      7 years ago
Posted in : SQL

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

Ads
View Answers

November 19, 2010 at 5:44 PM


Hi,

UNION is an SQL keyword used to merge the results of two or more tables using a Select statement, containing the same fields, with removed duplicate values(selects distinct values). UNION ALL does the same, however it persists duplicate values i.e. UNION ALL selects all values.

Thanks,


Ads









Related Tutorials/Questions & Answers:
Advertisements

Ads

 
Advertisement null

Ads