IT Community - Software Programming, Web Development and Technical Support

What is the difference between UNION and UNIONALL in SQL Server?

This is a discussion on What is the difference between UNION and UNIONALL in SQL Server? within the Database Support forums, part of the Web Development category; What is the difference between UNION and UNIONALL in SQL Server?...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1  
Old 07-25-2007, 04:37 AM
bluesky bluesky is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 667
bluesky is on a distinguished road
Question What is the difference between UNION and UNIONALL in SQL Server?

What is the difference between UNION and UNIONALL in SQL Server?
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 07-25-2007, 04:53 AM
kingmaker kingmaker is offline
D-Web Genius
 
Join Date: Jun 2007
Posts: 881
kingmaker is on a distinguished road
Send a message via MSN to kingmaker
Default Re: What is the difference between UNION and UNIONALL in SQL Server?

UNION: Eliminates duplicates

UNION ALL: Retains duplicates

Both these are used to combine the results of different SELECT statements.
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Make out of Structure and Union velhari C and C++ Programming 2 04-03-2008 02:55 AM
Union and Union All itbarota Database Support 2 03-03-2008 12:41 AM
UNION ALL faster than a UNION? vadivelanvaidyanathan Database Support 4 08-18-2007 01:04 AM
what is the UNION in c++? with Example sundarraja C and C++ Programming 1 07-20-2007 06:44 AM
What's the difference between a structure and a union prasath C and C++ Programming 1 07-18-2007 04:14 AM


All times are GMT -7. The time now is 09:42 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.
Our Partners
One Way Moving Companies | Stamford Dentist | Euro Millions Lottery | Home Loans| Furniture

SEO by vBSEO 3.0.0