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?
Answer Posted / sankar
You can also use VALUE
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What does db2 mean?
what is db2 restart?
What is the role of data manager in the db2 database?
What is dbrm? What it contains?
How to fetch the last row from the table in SQL (db2)?
Why do chiropractors use drop table?
Explain the function done by data manager?
What do you mean by rollback?
Is the primary key a clustered index?
Comment whether the cursor is closed during commit or not.
What is cascading rollback?
What is the advantage in De-normalizing tables in DB2?
Are views updateable?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is performance tuning db2?