Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between join and union?
- 4 Answers
- 18977 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
How does cobol compile db2 program?
What is copy pending status in db2?
Explain about rct.
What is cascading rollback?
What is the purpose of rollback and commit?
What is null value in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
How do you stop a db2 database in linux?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is drop table?
Can we update view in db2?
What is the advantage in De-normalizing tables in DB2?
List out the buffer pools in db2
What is bind plan?
Mention some fields that are a part of sqlca.
