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 commit in db2?
What is buffer pool in the db2 database?
What is RUNSTATS?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
how to get duplicate records from tables?write qurey for this?
What is page size in db2?
What is a Cartesian product?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
How to find the maximum value in a column in the db2 database?
How to create backup table in db2?
What are the full forms of spufi and dclgen and why are they used?