Explain an outer join?
Answer / vamsikrishnamraju
An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What are the functions in DB2?
what are bind concepts in db2 cobol?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
what is the maximum number of tables that can be joined ?
Why use RUNSTAT Utility?
What are the various locks available?
Can any one tell me about Restart logic in DB2.
What is an intent lock?
How many clustering indexes can be defined for a table?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is null in db2?