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 use of partition by in sql server?
What are system databases into sql server (2005/2008)?
Explain couple pf features of SQL server
Show Practically Sql Server Views are updatable?
What are recommended options to be used while using db mirroring? : sql server database administration
Explain the difference between cross join and full outer join?
can any one please send sql quries most used in applications.
What does indexation mean?
Explain what are the events recorded in a transaction log?
what type of indexes physically sort data?
What is difference between group by and having?
How to define output parameters in stored procedures?