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 are the uses of db2 optimizer?
How can deadlocks be resolved?
What is the role of schema in the db2 database?
What is the difference between bind and rebind in db2?
Why do we use cursor?
How does a cursor work?
what is diffrence b/w file-aid tool and file-aid utility???
Define data page.
What is netezza database?
What are the bind parameters ibm db2?
Mention the definition of cobol in varchar field.
What is database reorganization?
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.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Is ibm db2 free?