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

What is a join and their types?

Question Posted / honeysukumar

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 xml indexes?

0 Answers  

List the ways in which dynamic sql can be executed?

0 Answers  

how can i store resumes in database?

3 Answers   HCL,

What is analysis service repository?

0 Answers  

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  




What is index, cluster index and nonclustered index?

0 Answers  

Can sql server 2016 run on windows 7?

0 Answers  

How to truncate a table first before running a package?

1 Answers  

Explain linked server in sql?

0 Answers  

How to create indexed view?

0 Answers  

what is differece between union and union all

6 Answers  

What is scheduled job and how to create it?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories