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
- 6575 Views
- I also Faced
- E-Mail Answers
Answer Posted / scott
Use the COALESCE function
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is dbrm in db2 database?
Explain the function done by data manager?
What are the benefits of using the db2 database?
How do I delete a table in db2?
Why do we use cursor?
What is copy pending status in db2?
is it compulsory commitment control in journal?
What is db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is catalog database in db2?
List down the data types in the db2 database.
What db2 400?
What is clone table?
What is role in db2?
What is phantom read in db2?
