Which one allows duplicate values Union or Union All ?

Answers were Sorted based on User's Feedback



Which one allows duplicate values Union or Union All ?..

Answer / mahesh

union all allows duplicates
union doesnt allows duplicates

Is This Answer Correct ?    5 Yes 0 No

Which one allows duplicate values Union or Union All ?..

Answer / naveen87ginjupalli

Union All allows duplicate values.

Is This Answer Correct ?    4 Yes 0 No

Which one allows duplicate values Union or Union All ?..

Answer / surendra reddy

union does not allow duplicates

union all allowed duplicate values

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is an instance database?

0 Answers  


how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,


How is deadlock resolved?

0 Answers  


What do you mean by storage group (stogroup)?

0 Answers  


What is CHECK PENDING ?

5 Answers  






How to execute stored procedures?

0 Answers  


What is a storage group (stogroup)?

0 Answers  


db2 restart logic ?

1 Answers   DELL, HTC, UHG,


Explain in detail about buffer manager and its functionalities?

0 Answers  


What information is used as input to the bind process?

2 Answers  


What is the physical storage length of the data types date, time, and timestamp?

0 Answers  


What is check constraint in db2?

0 Answers  


Categories