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
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the clustering index in the db2 database?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How do you select a row using indexes in db2?
What is the role of union all and union
Which components manage deadlocks in db2?
Explain about open switch business continuity software?
What is null value in db2?
What is the advantage in De-normalizing tables in DB2?
What is table space in db2?
what is a corelated subquerry?
What is dbrm?
What is the use of runstats in db2?
What is syscat in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?