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
- 5977 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 bind and rebind in db2?
What are db2 tables?
Is ibm db2 open source?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Can we update view in db2?
Define db2.
Explain various types of locks in db2?
What is with ur in db2?
Mention the definition of cobol in varchar field.
Explain about open switch business continuity software?
What is universal database?
What is release/acquire in bind?
What is the maximum No of rows per page?
List out the buffer pools in db2
What is the difference between plan and package in db2?
