how many joins we can write if at all we have n no of
tables
Answers were Sorted based on User's Feedback
Answer / soni
To join n no. of tables ,we required n-1 join conditions
Is This Answer Correct ? | 31 Yes | 3 No |
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 |
Answer / shivaraj
n no of As many u want and complecation of the query
Is This Answer Correct ? | 2 Yes | 12 No |
What is the purpose of sql profiler in sql server?
What is the maximum rows in sql server table?
How can I create a new template for import ? : sql server management studio
can any body tell me how to know the password of current user in sql server
what operator performs pattern matching?
What is explicit cursors?
How to use "begin ... End" statement structures in ms sql server?
Find nth lowest salary or get nth lowest salary?
What is difference between inner join and join?
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
How to generate random numbers with the rand() function in ms sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?