User Id :
Stay Signed In
Write For Us
Topic: What is the difference between UNION ALL Statement and UNION
29 Oct 2010 at 11:50 PM
What is the difference between UNION ALL Statement and UNION.
Re: What is the difference between UNION ALL Statement and UNION
01 Nov 2010 at 12:03 AM
- this command will allow you to join multiple datasets into one dataset and will remove any duplicates that exist. Basically it is performing a DISTINCT operation across all columns in the result set.
- this command again allows you to join multiple datasets into one dataset, but it does not remove any duplicate rows. Because this does not remove duplicate rows this process is faster, but if you don't want duplicate records you will need to use the UNION operator instead.
Total Replies: 1
Featured Text Ad
© 2017-2018 DotNetLogix. All rights reserved.
Privacy and Policy