I have to display ten columns values from diffrent ten
tables.
how many joins are require?

Answer Posted / sachin

i Think there is formula 2n-1

where n is the number of table
so, answer will be 2*10-1=19

Is This Answer Correct ?    2 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scheduled job and how to create it?

556


What is encryption key?

86


How many types of objects are there?

511


Mention what are the different types of ssrs reports?

102


What is row_number()?

595






What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

602


How to use column default values in insert statements in ms sql server?

536


Ways to improve the performance of a SQL Azure Database?

103


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

546


What are the types of subquery?

557


What is cdc in sql server?

580


Define synonym?

733


What is the recommended total size of your memory optimized tables?

536


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2091


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

652