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 |
How can you do the explain of a dynamic sql statement?
What will the COMMIT accomplish?
How to check sequence on a table in db2?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Name some fields from SQLCA
pls explain the precompilation process of cobol-db2 pgm
What is the significance of DB2 free space and what parameters control it?
Give a brief description of db2 isolation levels?
How do I delete a table in db2?
What is meant by dclgen?
Do we need cursor for Count(*)?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,