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
- 6707 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 commit in db2?
Can we insert update delete in view?
Which isolation level provides maximum concurrency?
Which is faster delete or truncate?
What are packages in db2?
How to find the maximum value in a column in the db2 database?
What do you mean by commit and rollback?
Explain correlated sub-queries.
Explain about dbrm.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
When reorg is used?
What does runstats do in db2?
What is the use of runstats in db2?
What is the default page size of buffer pools?
What is buffer pool in the db2 database?
