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 |
Name the different types of Table spaces.
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is ibm db2 connect?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
what is different three logs in DB2?
How to take backup of table in db2?
Where can you declare a cursor in a cobol-db2 program?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
Are views updateable?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?