Answer Posted / s
Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.
Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
B37 abend during spufi?
What is rct?
Name the various locking levels available?
What is the use of predicate?
Define db2.
What is null in db2?
What is ibm db2 used for?
How do I import data from excel to db2?
What is consistency token in db2?
What do you mean by cursor?
What are db2 objects?
Explain package in db2 and its advantages?
Explain in brief how does db2 determine what lock-size to use?
Is the primary key a clustered index?
What is db2 look?