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.



OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPL..

Answer / 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

More DB2 Interview Questions

What is package versioning? Please give an example.

1 Answers  


What is index in db2?

1 Answers  


how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   HeadStrong, Amdocs,


What do you mean by commit and rollback?

0 Answers  


What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  






Explain the benefits you can get from mainframe connect?

0 Answers  


what are bind concepts in db2 cobol?

0 Answers  


if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


What are the various locks available?

5 Answers   CTS,


What is the max length of sqlca?

0 Answers  


What is a DB2 bind?

1 Answers   Logica CMG,


What is the difference between nvl and coalesce?

0 Answers  






Categories