SQL: Union And Union ALL
Union is one of the SQL syntax for combine the results of two queries together.
Do you know what is are the differences between UNION and UNION ALL ? (ehee….this is one of my interview question,lucky i know the answer. :D)
The UNION ALL command is equal to the UNION command, except that UNION ALL selects all values.(including all the duplicate values)
Links:
http://www.w3schools.com/sql/sql_union.asp
Happy Programming….
If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !
![[Ask]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/ask.png)
![[Bloglines]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/bloglines.png)
![[del.icio.us]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/digg.png)
![[Furl]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/furl.png)
![[StumbleUpon]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/technorati.png)


Google…
Google is the best search engine…