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
- 5922 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
When the like statement is used?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the maximum length of sqlca?
what is the difference between join and union?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What do you need to do before you do EXPLAIN ?
What are the various isolation levels possible?
How to view db2 table structure?
What is filter factor?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is cloudant database?
COBOL 
