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 do I import data from excel to db2?
How to create backup table in db2?
What is db2 optimizer?
What parameters are used to control the free space in DB2?
How do I add a column to an existing table in db2?
How to find the maximum value in a column in the db2 database?
Why do we need reorg in db2?
What is the physical storage length of time data type?
define clustering index.
What is role in db2?
How many databases can be created inside an instance in db2 ?
List out the buffer pools in db2
How do I copy a table in db2?
What are the contents of dclgen?
Explain the benefits you can get from mainframe connect?