GeekInterview.com
Series: Subject: Topic:
Question: 3 of 4

What is the difference between UNION and UNION ALL ?

Asked by: Interview Candidate | Asked on: Jun 6th, 2005
Showing Answers 1 - 4 of 4 Answers
kris

Answered On : Mar 14th, 2005

The difference between UNION ALL and UNION is that, while UNION only selects distinct values, UNION ALL selects all values.

Yes  1 User has rated as useful.
  
Login to rate this answer.
Nagaraja Rao

Answered On : Jun 6th, 2005

Union will filter duplicate values where as union all will not filter duplicate values

Yes  1 User has rated as useful.
  
Login to rate this answer.

In "union" only distinct values will be selected but in "union all "values will be selected irrespective of its frequency.

Yes  1 User has rated as useful.
  
Login to rate this answer.

The difference between UNION ALL and UNION is that, while UNION only selects distinct values, UNION ALL selects all values.When ever we say union the data type is supposed to be same

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.