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

Answers were Sorted based on User's Feedback



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

Answer / soni

To join n no. of tables ,we required n-1 join conditions

Is This Answer Correct ?    31 Yes 3 No

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

Answer / ali razvi

N-1

Is This Answer Correct ?    19 Yes 2 No

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

Answer / vamsi

n-1

Is This Answer Correct ?    9 Yes 0 No

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

Answer / deepak

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

Is This Answer Correct ?    6 Yes 0 No

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

Answer / shivaraj

n no of As many u want and complecation of the query

Is This Answer Correct ?    2 Yes 12 No

Post New Answer

More SQL Server Interview Questions

Explain different types of Normalization.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,


Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,


What do you understand by recursive stored procedure?

0 Answers  


How to count rows with the count(*) function in ms sql server?

0 Answers  


What are three major types of constraints?

0 Answers  






How do you fine the performance tunning?

2 Answers   Accenture,


What does it mean to be in union?

0 Answers  


what are the advanced features in sql 2008?

2 Answers   Wipro,


what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  


How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  


What is a domain constraint give an example?

0 Answers  


When is update_statistics command used?

0 Answers  


Categories