what is the difference between join and union?
- 4 Answers
- 17019 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s
Join returns only rows that are qualified based on the Join
predicate. Whereas UNION retrieves both result sets above
and below the UNION operator and sorts to remove duplicates
before it returns the First row to the pgm
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
What is dbrm? When it will be created?
What is the maximum size of a char data type in db2?
What is buffer pool?
Explain about dbrm.
What are the various data types available in db2?
What does db2 plan contain?
What is reorg?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the role of the data page in the db2 database?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
List down the types of triggers in the db2 database?
Why select is not preferred in embedded sql programs?
How can record locking be achieved in those DB2 versions which do not support it?
What is db2 command?
How to execute stored procedures?
