Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 6763 Views
- Syntel, I also Faced
- E-Mail Answers
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
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is blu acceleration in db2?
What is a db2 tablespace?
Mention the downsides of page level lock.
What is db2 command?
What is the difference between oracle and db2?
Explain how can you do the explain of a dynamic sql statement?
What is query_cache_limit?
What is the maximum length of sqlca?
What does db2 plan contain?
Explain various types of locks in db2?
What is db2 bind process?
What is drop table?
What is phantom read in db2?
What is the use of commit in db2?
