Which one allows duplicate values Union or Union All ?
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
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How do I delete a table in db2?
Who uses db2?
What is host variable in db2 cobol?
What is explain plan in db2?
Are views updateable?
What is the maximum size of varchar data type in db2?
Are view updateable?
What are the 2 sqlcodes that are returned?
What is the difference between bind and rebind in db2?
How can we read records for specific member in CL? AND rpg?
What is the clustering index in the db2 database?
Which command is used to remove all rows from a table?
Describe major components of db2?
Comment whether the cursor is closed during commit or not.