The minimum number of joins required are N-1. Maximum can be up to 256.

how many joins we can write if at all we have n no of
tables

Question Posted / deepak

Answer Posted / deepak

The minimum number of joins required are N-1. Maximum can
be up to 256.

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the disadvantages of cursors?

1144

What is user-defined functions? What are the types of user-defined functions that can be created?

1037

how can you attach more than 20 ldf files in sql server

2004

Does a sql server 2005 select statement require a from?

1025

How many categories of functions based their return modes?

1103

What is clustered vs nonclustered index?

948

What are the types of table?

980

What is the concept of optimization?

1060

What happens if ntwdblib.dll is missing on your machine?

1145

Explain following error properties?

1023

What is difference between group by and having?

944

How do users use Report Builder with SQL Server data sources?

160

How to change parameter value inside the report?

165

Tell me about the approaches which you used to counter the DI problems.

1356

What are parameterized reports? What are cascading parameters in ssrs reports?

156