what is the difference between join and union?
Answer Posted / lokesh chauhan
Join is used to established a conditional selection from 2
different tables, while union is used to select similar
data based on different conditions.
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the role of the data page in the db2 database?
Explain db2.
Mention the location where the output received from explain statement is stored.
Outputs of explain are with matchcols = 0. What does this signify?
What do you mean by storage group (stogroup)?
What is an instance in db2?
What is a Foreign Key?
Who uses db2?
How to view db2 table structure?
What is a cursor in programming?
What is multi row fetch in db2?
How do you stop a db2 database in linux?
List down the types of triggers in the db2 database?
How do you concatenate the firstname and lastname from emp table to give a complete name?