OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2
OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE
SAME THEN WHAT IS THE USE OF OUTER JOINS.
Answer Posted / ravi
Simple joins gives only matching/common values from two or
more tables
If you have mentioned only Outer joins then it is same as
simple join gives the matching values from two or more
tables but outer joins are of two types--- right outer join
and left outer join
for right outer join--- it will give non matching rows also
from right table in addition to matching rows
for left outer join-- it will give non matching rows also
from left table in addtion to matching rows
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Where do you specify them?
Explain the contents that are a part of dclgen.
What is cascading rollback?
Name the various locking levels available?
What is nvl in db2?
What does runstats do in db2?
What are packages in db2?
Mention the definition of cobol in varchar field.
What is the difference between db2 and oracle?
What is a buffer in memory?
What is page size in db2?
What is explain plan in db2?
Define buffer pool.
What is declare cursor?
How does a cursor work?