Interested to Buy Any Domain ? << Click Here >> for more details...
For unmatched rows returned from an outer join, the column
values in the other table are set to null e.g If A OUTER
JOIN B returns some unmatched rows from A, the
corresponding column values in B will be set to null. What
can be done so that a null value is not displayed for these
columns?
- 3 Answers
- 6746 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
How to find primary key of a table in db2?
What is db2 bind process?
What types of tables are there in the db2 database?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
How to get Top 10 Salaries from a Table
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
what is the maximum number of tables that can be joined ?
pls tell me abt the normalization five types....
What is a collection in db2?
Explain various types of locks in db2?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
COBOL 
