Which one allows duplicate values Union or Union All ?
- 3 Answers
- 6299 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 the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
Define sqlca.
What is a db2 schema?
What is precompiler in db2?
How can you do the explain of a dynamic sql statement?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is a composite index and how does it differ from a multiple index?
Explain about open switch business continuity software?
pls explain the precompilation process of cobol-db2 pgm
How to resolve -504 sql code in DB2?
What is the role of data manager in the db2 database?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
COBOL 
