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
What are foreign keys in db2?
Explain packages.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What's The Percentage Free Space ?
What is plan in cobol db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a db2 cursor?
What is the physical storage length of date data type?
What is a dbrm in db2?
What is db2 optimizer?
What is the difference between oracle and db2?
What types of tables are there in the db2 database?
Why do we need reorg in db2?
What is collection in db2 bind?
Which component is responsible for processing sql statements and selecting access paths?