what is the difference between join and union?
Answer Posted / ananda kumar
join retrive the data more than one table using single sql
query where as union combine the results of two or more sql
queries.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Define db2.
How do I add a column in db2?
What is precompiler in db2?
What is dbrm? When it will be created?
What is the use of db2?
How to view db2 table structure?
What is buffer pool?
How is deadlock resolved?
What is cobol db2?
What do you mean by commit and rollback?
How to test SQL -911 error while developing COB-DB2 program
How is a typical db2 batch pgm executed?
What is query_cache_limit?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Mention the various locks that are available in db2.