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

Ads
 

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

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

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:
What is the difference between UNION and UNION ALL in SQL?
union
Advertisements
SQL UNION ALL Operator
SQL UNION Operator
What is the difference between the >> and >>> operators?
SQL Union with order by
what is the difference between extends and implements
what is the difference between extends and implements
What is the difference between PHP4 and PHP5?
What is difference between a PROCEDURE & FUNCTION ?
What is the difference between $message and $$message?
what is the Difference between weblogic and jboss?
what is the difference between pop and oop
What is the difference between hibernate and spring
What is the difference between a constructor and a method?
SQL Union
What is difference between the java and javascript?
What is difference between TRUNCATE & DELETE
merge tables in sql using union
What is the difference between a JDK and a JVM?
What is difference between Path and Classpath?
What is difference between the java and javascript?
What is the difference between JPA and Hibernate?
What is the difference between ereg_replace() and eregi_replace()?
What is the difference between the functions unlink and unset?
What are the difference between abstract class and interface?
What’s the difference between include and require?
what is the difference between distributed application and web application?
What’s the difference between load() and get()?
What is difference between singleton and prototype bean?
What is the difference between JSF, Servlet and JSP?

Ads