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 / mathur

Answers were Sorted based on User's Feedback



Types of joins ?..

Answer / ramesh yadav

IN ORACLE 9i.

Equi - Join = Both are same Names only different
simple join
inner join
Natural join
join

Non - Equi Join

Outer Join
Left outer join
Right outer joi
Full outer join

Self join
Cartesian Product

Is This Answer Correct ?    9 Yes 0 No

Types of joins ?..

Answer / bipin

sql-server

inner join
outer join
left outer join
right outer join
full outer join
cross join


oracle sql

inner join
outer join
left outer join
right outer join
full outer join
cross join
natural join

Is This Answer Correct ?    8 Yes 2 No

Types of joins ?..

Answer / vinodkumar.r

2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

Can you rollback after commit?

0 Answers  

What is a dynamic query?

0 Answers  

Is sql an operating system?

0 Answers  

How many functions are there in sql?

0 Answers  

Mention what are the benefits of pl/sql packages?

0 Answers  

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

what is 'mysqldump'? : Sql dba

0 Answers  

What is trigger in flip flop?

0 Answers  

What do you mean by “trigger” in sql?

0 Answers  

What is sap sql anywhere?

0 Answers  

Explain isolation levels. : Transact sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories