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
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How do you stop a db2 database in linux?
What is query_cache_limit?
What types of tables are there in the db2 database?
What does db2 plan contain?
What is the role of the data page in the db2 database?
Mention the location where the output received from explain statement is stored.
How do I delete a table in database?
How to execute stored procedures?
How to get the ddl of a table in db2?
What is the max length of sqlca?
Explain the benefits you can get from mainframe connect?
Define predicate?
What is null indicator in cobol db2?
Mention the different locking levels that are available in db2.
