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
- 6697 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
Is the primary key a clustered index?
What is with ur in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is reorg and runstats in db2?
Mention the different locking levels that are available in db2.
Can there be more than one cursor open for any program?
What is the max length of sqlca?
What is the maximum No of rows per page?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What's The Percentage Free Space ?
What is host variable?
Which isolation level provides highest data integrity?
What is the use of commit in db2?
How and when does the db2 enforces the unique key?
What is sqlca?
