yep. With COALESCE we can

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?

Question Posted / keshireddy

3 Answers
6858 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

Please Help Members By Posting Answers For Below Questions

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1125

How do you eliminate duplicate values in db2?

1256

What is meant by explain?

1189

What is collection in db2 bind?

1057

What is ibm db2 connect?

1049

What is rebind in db2?

1113

How to test SQL -911 error while developing COB-DB2 program

7658

What is the use of db2 optimizer?

1168

What is db2?

1226

What is query_cache_limit?

1027

Is db2 free?

1129

What is cloudant database?

1150

What are the prerogatives?

1123

How to compare data between two tables in db2?

1133

Explain the function done by data manager?

1326