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 |
What is an instance database?
how to resolve -811 sqlcode .give clear explaination
How is deadlock resolved?
What do you mean by storage group (stogroup)?
What is CHECK PENDING ?
How to execute stored procedures?
What is a storage group (stogroup)?
db2 restart logic ?
Explain in detail about buffer manager and its functionalities?
What information is used as input to the bind process?
What is the physical storage length of the data types date, time, and timestamp?
What is check constraint in db2?