Which one allows duplicate values Union or Union All ?
Answers were Sorted based on User's Feedback
Answer / mahesh
union all allows duplicates
union doesnt allows duplicates
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / surendra reddy
union does not allow duplicates
union all allowed duplicate values
Is This Answer Correct ? | 1 Yes | 0 No |
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What action db2 takes when a program aborts in the middle of a transaction?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the difference between bind and rebind in db2?
Is db2 relational database?
What is the cascade rule and how does it relate to deletions made with a subselect?
What is the role of data manager in the db2 database?
What is ibm db2 client?
What are the various locks available?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is copy book?
List some fields from sqlca?