Which one allows duplicate values Union or Union All ?
- 3 Answers
- 6870 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
Why do we use cursor?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Which components manage deadlocks in db2?
What parameters are used to control the free space in DB2?
What is page size in db2?
How to connect to db2 database from windows command line?
What is ibm db2 connect?
What is the reason behind not using select * in embedded sql programs?
What is a trigger in the db2 database?
can we view the access paths created by dbrm ? how ? thx
Where can you declare a cursor in a cobol-db2 program?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Give the name of some fields form sqlca.
What's The Percentage Free Space ?
What is with ur in db2?
