Which one allows duplicate values Union or Union All ?
- 3 Answers
- 6315 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh
union all allows duplicates
union doesnt allows duplicates
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do you select a row using indexes in db2?
How can you classify the locks in db2?
What language is db2 written in?
Which command is used to remove all rows from a table?
What action db2 takes when a program aborts in the middle of a transaction?
What is the role of the data page in the db2 database?
Give a brief description of db2 isolation levels?
How to compare data between two tables in db2?
What is dpf in db2?
What are the two types of logging in the db2 database? Explain them.
How do I create a view in db2?
What kind of database is db2?
What is the syntax for FETCH in DB2 ?
what is the sqlcode -501
What is host variable in db2 cobol?
