Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is the difference between UNION and UNION ALL in SQL?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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


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


Advertisement
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,



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com