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
What is the difference between cursor stability and repeatable read isolation levels?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How do I optimize a query in db2?
Define predicate?
What is universal database?
Is db2 relational database?
Why do chiropractors use drop table?
What is buffer pool in the db2 database?
What is the use of predicate?
What is meant by dclgen?
What is a buffer in memory?
What is runstats utility in db2?
What is the difference between oracle and db2?
Explain various types of locks in db2?
What is a plan and package in db2?