Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


What are the functions in DB2?

3 Answers   Satyam,


what are bind concepts in db2 cobol?

0 Answers  


what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  


what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,


Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,


What are the various locks available?

5 Answers   CTS,


Can any one tell me about Restart logic in DB2.

2 Answers  


What is an intent lock?

3 Answers  


How many clustering indexes can be defined for a table?

2 Answers  


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  


What is null in db2?

0 Answers  


Categories