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 purpose of sql profiler in sql server?

0 Answers  


What is the maximum rows in sql server table?

0 Answers  


How can I create a new template for import ? : sql server management studio

0 Answers  


can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,


what operator performs pattern matching?

2 Answers  






What is explicit cursors?

0 Answers  


How to use "begin ... End" statement structures in ms sql server?

0 Answers  


Find nth lowest salary or get nth lowest salary?

0 Answers  


What is difference between inner join and join?

0 Answers  


can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,


How to generate random numbers with the rand() function in ms sql server?

0 Answers  


Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  


Categories