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 SQL Communications Area and what are some of its key fields?
How do you stop a db2 database in linux?
What is the format (internal layout) of ?TIMESTAMP??
how can u retrieve the data from null values using applicaion program.
Name the various locking levels available?
What keyword does an SQL SELECT statement use for a string search?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is data manager?
what is a collection?
How will fetch last 5 rows from table in db2
What is REORG? When is it used?
What are the uses of db2 optimizer?