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 |
wht r the requirements for writing a cobol-db2 pgm ?
What is ibm db2 connect?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
Are view updateable?
How to define the a field which accepts value till 99999.99 in db2
Why do we need reorg in db2?
What is meant by AUTO COMMIT?
How to define the data items to receive the fetch items for the SQL?
what is differnece between DROP TABLE & DELETE TABLE .
What is the physical storage length of timestamp data type?
What is reorg in DB2
How to connect to db2 database from windows command line?