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

Can sub report data source be different from that of the parent report?

121


What is the boxing and unboxing concept in .net?

710


Tell me the phases a transaction has to undergo?

719


What is normalization according to you and explain its different levels?

687


How to use clusters?

695






What are translations and its use? : sql server analysis services, ssas

797


What is the difference between an index and a unique index?

739


How do you identify a foreign key?

781


Can we perform backup restore operation on tempdb? : sql server database administration

754


Explain different types of collation sensitivity?

703


What is tablesample?

766


What are security principals used in sql server 2005?

662


How to change server name in sql server?

796


How to test odbc dsn connection settings?

707


What is compression - row-level and page-level compression?

687