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
- 6616 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 are the bind parameters ibm db2?
What is difference between isnull and coalesce?
What is dclgen in db2?
What is db2 stogroup?
What is the difference between db2 and oracle?
How do I add a column in db2?
What is meant by union and union all?
What os does db2 run on?
Explain about dbrm.
What does db2 plan contain?
What is role in db2?
what is utility for parm lib
What is dbrm? What it contains? When it will be created?
What is meant by explain?
Which command is used to connect to a database in DB2 ? Give the Syntax.
