What is an inner join, and an outer join ?
Answer / 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 |
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Why do we bind in db2?
what needs to be done if a table is in copy pending / check pending status?
What is the use of db2?
What is dclgen (declaration generator)?
What are the Isolation levels possible ?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is view db2?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What are foreign keys in db2?