Answer Posted / 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 |
Post New Answer View All Answers
Which component is responsible for processing sql statements and selecting access paths?
What types of tables are there in the db2 database?
What does reorg do in db2?
Which isolation level provides highest data integrity?
what is a corelated subquerry?
What is clone table?
How can deadlocks be resolved?
What are concurrency issues?
What is bind plan?
Why do we use cursor?
What is the physical storage length of time data type?
What is the physical storage length of date data type?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is universal database?
What are packages in db2?