What is the difference between UNION and UNION ALL ?

Showing Answers 1 - 4 of 4 Answers

kris

  • Mar 14th, 2005
 

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

Nagaraja Rao

  • Jun 6th, 2005
 

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

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

  Was this answer useful?  Yes

Give your answer:

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

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions