Which one allows duplicate values Union or Union All ?
- 3 Answers
- 6823 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 |
Can we insert update delete in view?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is difference between *omit and *nopass?
Is the primary key a clustered index?
Explain what are the various isolation levels possible?
What are packages in db2?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What are the uses of db2 optimizer?
What is a host variable?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
can i code union in cobol-db2 pgm ?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
COBOL 
