Interested to Buy Any Domain ? << Click Here >> for more details...
What is an inner join, and an outer join ?
- 1 Answers
- 12943 Views
- CTA, I also Faced
- E-Mail Answers
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 |
What type of database is db2?
What is the purpose of the WHENEVER statement?
Why do we bind in db2?
What can the SET option of the Repair Utility accomplish?
Why select is not preferred in embedded sql programs?
What do you mean by rollback?
What is a buffer pool?
explain about index with examples
How to connect to db2 database from windows command line?
What is release/acquire in bind?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
COBOL 
