Answer Posted / vamsikrishnamraju
An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between dbm cfg and db cfg file in db2 ?
Can you use max on a char column?
What is the difference between spufi and qmf?
Discuss about db2 bind?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What are union and union all?
What is the difference between plan and package in db2?
Is ibm db2 open source?
What is the use of value function?
Explain the function done by data manager?
What is explain plan in db2?
What is the clustering index in the db2 database?
Mention data types used in db2 ?
How does coalesce work?
can all users have the privilage to use the sql statement select * (dml)?