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
What is the advantage in De-normalizing tables in DB2?
What is buffer pool and list some of them?
What is a db2 package?
What do you mean by storage group (stogroup)?
what is a corelated subquerry?
What is db2 catalog database?
How is deadlock resolved?
What is null value in db2?
Explain various types of locks in db2?
Comment whether the cursor is closed during commit or not.
How do I change the column size in db2?
What is drop table?
What is the physical storage length of the data types date, time, and timestamp?
Explain correlated sub-queries.
What is the maximum No of rows per page?