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

what are three different authentications to connect linked servers?

1 Answers   CitiGroup,


How to delete a login name in ms sql server?

0 Answers  


How to download and install the scaled-down database adventureworkslt?

0 Answers  


What causes index fragmentation?

0 Answers  


What are the database roles? : sql server security

0 Answers  






What happens if you delete a table that is used by a view?

0 Answers  


Can we use where and having clause together?

0 Answers  


What is the difference between nvl and nvl2?

0 Answers  


How do I find query history in sql server?

0 Answers  


Explain sub-query?

0 Answers  


What is faster join or union?

0 Answers  


what is difference between having and where clause ?

3 Answers  


Categories