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
How can deadlocks be resolved?
Is the primary key a clustered index?
Why do we bind in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is consistency token in db2?
What is ibm db2 used for?
How does cobol compile db2 program?
What is blu acceleration in db2?
What is difference between isnull and coalesce?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is an instance in db2?
What is db2 look?
What is host variable?
What is the default page size of buffer pools?
What is a bind in db2?