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 the tcp/ip port on which sql server runs?

564


Can we write trigger for view?

551


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

541


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

582


What are the properties and different types of sub-queries?

558






Who developed sql server?

526


Explain the ways to controlling cursor behavior?

538


Can you name some of the dml commands in sql?

548


What is the ‘fillfactor’?

565


How many categories of functions based their return modes?

593


How fixed length strings are truncated and padded?

548


What do we have to check in database testing?

582


What is a non-clustered index?

562


how many layers of tcp/ip protocol combined of? : Sql server database administration

519


How to disable triggers using "disable trigger"?

556