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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Types of joins ?

Question Posted / wgk

Answers were Sorted based on User's Feedback



Types of joins ?..

Answer / khaleek

There are only three type of joins
1) Equi Join
2) Non Equi Join
3) Cartesian Product or Cross Join.

Further Equi Join and Non Equi join can be divided into
following categories.
1) Inner Join
2) Outer Join
3) Self Join

Again Outer can be divide into following categories.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join

For detail please see at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

what are the different tables present in mysql? : Sql dba

0 Answers  

Which is faster subquery or join?

0 Answers  

What is a join?

0 Answers  

What is pl/sql table? Why it is used?

0 Answers  

What is pl/sql table? Why is it used?

0 Answers  

how to get a list of all tables in a database? : Sql dba

0 Answers  

What is sql select statement?

0 Answers  

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

What are the two types of exceptions in pl/sql?

0 Answers  

how to sort records in sql?

3 Answers  

What is Histogram?

0 Answers   NIIT,

For more SQL PLSQL Interview Questions Click Here
Categories