Explain an outer join?



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

Post New Answer

More DB2 Interview Questions

how can we find nth max salary from A table

5 Answers   IBM,


what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,


how to resolve -805. give clear explination for that

2 Answers   IBM,


What are foreign keys in db2?

0 Answers  


Is db2 a mainframe?

0 Answers  


Which is faster delete or truncate?

0 Answers  


What is the difference between Primary key and unique index?

6 Answers  


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


What is a composite index and how does it differ from a multiple index?

1 Answers  


What is the difference between nvl and coalesce?

0 Answers  


How does db2 sample database connect?

0 Answers  


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


Categories