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 |
Why cursor is used in db2?
Why db2 is called db2?
What is the purpose of the QUIESE Utility?
What is sqlca’s maximum length?
what is a trigger and types of triggers
How do I delete a table in database?
Can you access the DB2 Directory table using SQL?
How do I delete a table in db2?
what's the best lock size that you could use when you create a tablespace?
Explain what a plan is?
what is the name of the default db2 catalog database?
Which transaction use a command thread ?