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

What is the use of partition by in sql server?

0 Answers  


What are system databases into sql server (2005/2008)?

0 Answers  


Explain couple pf features of SQL server

2 Answers  


Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,


What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  






Explain the difference between cross join and full outer join?

0 Answers  


can any one please send sql quries most used in applications.

2 Answers  


What does indexation mean?

0 Answers  


Explain what are the events recorded in a transaction log?

0 Answers  


what type of indexes physically sort data?

3 Answers  


What is difference between group by and having?

0 Answers  


How to define output parameters in stored procedures?

0 Answers  


Categories