Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between join and union?
- 4 Answers
- 18579 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 an instance in db2?
What is node in db2?
What is temporal table in db2?
Explain the contention situations caused by locks?
What is schema in db2?
What is cloudant database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How do I optimize a query in db2?
What is db2?
How to compare data between two tables in db2?
What is meant by explain?
What is a Foreign Key?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
what is utility for parm lib
Mention the downsides of page level lock.
