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
How many types of triggers in sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
can an automatic recovery be initiated by a user? : Sql server administration
What is the difference between upgrade and migration in sql server?
How to create a user to access a database in ms sql server using "create user" statements?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Explain the creation and execution of a user-defined function in the sql server?
Explain what is the function of sql server agent windows service?
What are the types of subquery?
What are the steps to process a single select statement?
What are the types of processing and explain each? : sql server analysis services, ssas
What is thr feature of change data capture?
What is query parameter in ssrs?
What is a primary key?
Using the customer, and order table in northwind database, please write a query to produce xml?