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 |
Is it possible to create an Instance in DB2 using DB2 Control Center ?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Which catalog tables contain authorization information?
How do I add a column to a table in db2?
What's The Percentage Free Space ?
What does reorg do in db2?
What is the difference between IN subselects and EXISTS subselect?
How can we define a table? How can we apply SEARCH ALL on it ?
Name the lockable units in DB2?
What information can you find in SYSIBM.SYSLINKS table?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is meant by concurrency?