Which one allows duplicate values Union or Union All ?
- 3 Answers
- 6906 Views
- I also Faced
- E-Mail Answers
Answer Posted / surendra reddy
union does not allow duplicates
union all allowed duplicate values
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is dpf in db2?
What is dclgen (declaration generator)?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Is schema the same as database?
what is the sqlcode -501
What is cursor in dbms?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the difference between db2 and oracle?
What is the purpose of using commit?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Can you tell me how can you find out the # of rows updated after an update statement?
What is temporal table in db2?
What is a page in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What does runstats do in db2?
