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 |
How to create nested stored procedure?
What are the recovery models for a database?
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
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is the contrast amongst drop and truncate?
What extended events?
What is the purpose of object explorer and its features? : sql server management studio
What is conditional split?
What do you mean by COLLATION?
Can another user execute your local temporary stored procedures?
Can primary key be null?