Which one allows duplicate values Union or Union All ?

Answer Posted / mahesh

union all allows duplicates
union doesnt allows duplicates

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is the value function used?

713


What is dbrm library?

664


How to connect to db2 database from windows command line?

651


What does reorg do in db2?

655


What is the information associated with sysibm.syslinks table?

755






What is ibm db2 connect?

652


What is declare cursor?

706


What is the clustering index in the db2 database?

651


Mention the downsides of page level lock.

813


What are the full forms of spufi and dclgen and why are they used?

734


What is the use of db2?

681


List out the buffer pools in db2

723


Is db2 relational database?

650


What is load utility in db2?

758


Define predicate?

749