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 |
Explain in brief how does db2 determine what lock-size to use?
How do I import a csv file into db2?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What does a deadlock mean in DB2?
What is plan in cobol db2?
What is Skeleton cursor table (SKCT)?
How do I create a view in db2?
How does db2 sample database connect?
What is the use of runstats in db2?
What is a cursor in programming?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?