Which one allows duplicate values Union or Union All ?

Answer Posted / naveen87ginjupalli

Union All allows duplicate values.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why cursor is used in db2?

568


How to run db2 command in windows?

637


How to get the ddl of a table in db2?

671


What is innodb buffer pool?

556


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1646






What is runstats and reorg in db2?

789


Explain about rct in db2?

633


What is the reason behind not using select * in embedded sql programs?

597


What language is db2 written in?

591


List out the buffer pools in db2

622


Is db2 a database?

569


Mention the downsides of page level lock.

701


What is cursor stability in db2?

802


What is page size in db2?

559


How to check sequence on a table in db2?

596