Which one allows duplicate values Union or Union All ?
- 3 Answers
- 6759 Views
- I also Faced
- E-Mail Answers
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 |
What is a page in db2?
What is the use of predicate?
What is the latest version of ibm db2?
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 is the maximum number of columns in a db2 table?
Explain various types of locks in db2?
What do you do to keep the cursor from closing after a commit?
How can you find out the # of rows updated after an update statement?
what is diffrence b/w file-aid tool and file-aid utility???
Explain the function done by data manager?
What are the three DB2 date and time data types and their associated functions?
What is db2 stogroup?
COBOL 
