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
- 6753 Views
- I also Faced
- E-Mail Answers
Answer Posted / keshireddy
yep. With COALESCE we can
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is db2 purescale?
Is schema the same as database?
What is the maximum No of rows per page?
What is package in db2 mainframe?
What is difference between alias and synonym in db2?
What is netezza database?
How do I copy a table in db2?
What is drop table?
What is catalog database in db2?
What is database reorganization?
What is access path in db2?
Why do we use cursor?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is phantom read in db2?
What are the 2 sqlcodes that are returned?
