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

How to create nested stored procedure?

0 Answers  


What are the recovery models for a database?

0 Answers  


How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,


you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

0 Answers  


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  






What is the contrast amongst drop and truncate?

0 Answers  


What extended events?

0 Answers  


What is the purpose of object explorer and its features? : sql server management studio

0 Answers  


What is conditional split?

0 Answers  


What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,


Can another user execute your local temporary stored procedures?

0 Answers  


Can primary key be null?

0 Answers  


Categories