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
- 6643 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 the use of dclgen in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What are host variables in db2?
What are the various isolation levels possible?
What do you mean by rollback?
can all users have the privilage to use the sql statement select * (dml)?
What is an instance database?
What is explain plan in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the use of value function?
What is the use of with ur in db2?
What is cursor with hold option in db2?
What is dbrm library?
What type of database is db2?
Mention the location where the output received from explain statement is stored.
