Explain an outer join?
Answer / 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 |
What is the role of data manager in the db2 database?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What are the benefits of using the db2 database?
What is alias in db2?
how to unload different table data into different gdg files/ vsam files.
what is Runstats? Whem will u choose to runatats?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How to compare data between two tables in db2?
What is the syntax for creating a table in the db2 database?
What is a db2 schema?
What is the purpose of the WHENEVER statement?
How to see the structure of db2 table??