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


Please Help Members By Posting Answers For Below Questions

What is best institute to Learn DotNET And SQL in chennai?

1695


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

1221


What do you mean by an execution plan?

568


What is SQL Azure Fabric?

92


What does ss stand for sexually?

592






explain what is raid and what are different types of raid configurations? : Sql server database administration

552


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

516


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

730


What's new in sql management studio for sql server? : sql server management studio

586


Can a table be moved to different filegroup?

574


What is autocommit mode in sql server?

549


Explain triggers in sql?

558


What is sql server schema compare? How we can compare two database schemas?

566


Why main is user defined function?

571


Explain the flow of creating a cube? : sql server analysis services, ssas

629