how many joins we can write if at all we have n no of
tables
Answer Posted / deepak
The minimum number of joins required are N-1. Maximum can
be up to 256.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is best institute to Learn DotNET And SQL in chennai?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What do you mean by an execution plan?
What is SQL Azure Fabric?
What does ss stand for sexually?
explain what is raid and what are different types of raid configurations? : Sql server database administration
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What's new in sql management studio for sql server? : sql server management studio
Can a table be moved to different filegroup?
What is autocommit mode in sql server?
Explain triggers in sql?
What is sql server schema compare? How we can compare two database schemas?
Why main is user defined function?
Explain the flow of creating a cube? : sql server analysis services, ssas