Interested to Buy Any Domain ? << Click Here >> for more details...
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 the various isolation levels possible?
What is difference between rollback and commit?
What is dbrm?
What is runstats and reorg in db2?
What is check constraint. Explain with example.
Name the lockable units in DB2?
How to take backup of table in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Explain in brief how does db2 determine what lock-size to use?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is a bind card?
What is the use of value function?
How to create backup table in db2?
What is consistency token in db2?
What is the difference between using bind () and rebind () methods of naming class?
