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 |
Define declaration generator (dclgen).
What is buffrpool? Where we use it ?
What is collection in db2 bind?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is data manager?
Define check constraint.
What is db2 optimizer?
How to handle null values in db2
How do you eliminate duplicate values in db2?
Explain the function done by data manager?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What is the maximum number of columns in a db2 table?