1.Inner Join - Equi Join - Natural Join 2.Outer Jo

How many types of Joins in SQL Server 2005?

Question Posted / prasanna

9 Answers
12211 Views
CarrizalSoft Technologies, HCL, I also Faced
E-Mail Answers

Answer Posted / prasanna

1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between views and stored procedures?

1028

What are the reporting services components?

144

How to make conditional sum in ssrs?

183

Which table keeps the locking information?

984

What is difference between rollback immediate and with no_wait during alter database?

1131

What is the default Port No on which SQL Server listens?

1175

how to overcome kernel isssues

1687

List the different normalization forms?

1020

How do you size a resultset?

965

what are the different ways to return the rowcount of a table?

1049

Do you know what is rank function?

1125

In which files does sql server actually store data?

950

Explain how to send email from sql database?

1103

What is the difference between for trigger and after trigger?

1157

Does windows server 2016 come with sql server?

985