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

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  


What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  


What is the difference between bind and rebind in db2?

0 Answers  


Is db2 relational database?

0 Answers  






What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


What is the role of data manager in the db2 database?

0 Answers  


What is ibm db2 client?

0 Answers  


What are the various locks available?

5 Answers   CTS,


Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  


What is copy book?

1 Answers   Thomson Reuters,


List some fields from sqlca?

0 Answers  


Categories