what is the difference between join and union?
Answer Posted / suresh ramaiyan
Join is used retrive the data from two or more tables.
Union is used to join the result of two queries.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is a page in db2?
What is clone table?
What is reorg?
Explain about rct.
How can the duplicate values be eliminated from db2 select?
What is concurrency?
What is the use of reorg in db2?
How do I delete a column in db2?
Outputs of explain are with matchcols = 0. What does this signify?
How to fetch the last row from the table in SQL (db2)?
How do you pull up a query which was previously saved in qmf?
What is sqlca’s maximum length?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How to find primary key of a table in db2?
Explain in brief how does db2 determine what lock-size to use?