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

What does reorg do in db2?

655


What is the difference between plan and package in db2?

689


How to resolve deadlock issue

18559


How is the value function used?

713


What is dpf in db2?

753






What is db2 look?

668


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2782


What is deadlock in db2?

677


What is a page in db2?

692


What do you mean by cursor?

683


List out the buffer pools in db2

723


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

678


How do you concatenate the firstname and lastname from emp table to give a complete name?

682


What is clone table?

684


Explain packages.

756