Which one allows duplicate values Union or Union All ?
- 3 Answers
- 6316 Views
- I also Faced
- E-Mail Answers
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 does db2 blu stand for?
What is the syntax for creating a table in the db2 database?
Name the various locking levels available?
What is a db2 tablespace?
what is the responsibility of the construction superintendent
What are types of indexes?
How is a typical db2 batch pgm executed?
How is deadlock resolved?
Which isolation level provides highest data integrity?
What is null value in db2?
What is phantom read in db2?
What is db2 connect?
How can record locking be achieved in those DB2 versions which do not support it?
What is nvl in db2?
Explain various types of locks in db2?
