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


What is a join and their types?

Answers were Sorted based on User's Feedback



What is a join and their types?..

Answer / s.chithiravelu

Join can be defined as an operation that includes the
retrieval of data from more than one table at a time.

Various Types of Joins:

Inner Joins
Outer Joins
Cross Joins
Equi Joins
Natural Joins
Self Joins

Is This Answer Correct ?    4 Yes 0 No

What is a join and their types?..

Answer / hari

Joins are reterving the data from the multiple tables
Inner Join
Outer Join-left outer join
-----------right outer Join
-----------Full outer Join
Cross Join

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

How many cores do I need for sql server 2016?

0 Answers  


What do you understand by a view? What does the with check option clause for a view do?

0 Answers  


Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  


What are the triggers in sql?

0 Answers  


What is inner join in sql server joins?

0 Answers  


What is Dependency Injection and provide example?

0 Answers  


What is raiseerror? What is raiseerror?

0 Answers  


Explain the disadvantages/limitation of the cursor?

0 Answers  


Explain difference between cross join and full outer join?

0 Answers  


Explain what are commit and rollback in sql?

0 Answers  


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  


System variable and temporary variables

0 Answers   Wipro,


Categories