Interested to Buy Any Domain ? << Click Here >> for more details...
Which one allows duplicate values Union or Union All ?
- 3 Answers
- 7531 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 is consistency token in db2?
What is db2 stogroup?
What is package in db2 mainframe?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the reason behind not using select * in embedded sql programs?
What action db2 takes when a program aborts in the middle of a transaction?
Where can you declare a cursor in a cobol-db2 program?
List down the types of triggers in the db2 database?
What is a db2 collection?
What is the use of runstats in db2?
Is db2 a database?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Are views updateable?
How do I optimize a query in db2?
What is database alias db2?
