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 to trouble shoot if unable to connect SQL Server
How self join is different from outer join?
What is difference between equi join and natural join?
Can I use sql azure as a backup with log shipping or database mirroring?
How many non clustered indexes there can be on table ?
What are the components of dbms?
What is a functions and types in sql server?
What is an index in sql?
What does ss stand for sexually?
When to use Inner join & when to use subquery?
List few advantages of stored procedure.
How to verify the port number of the sql server?
What are the differences between union, intersect, and minus operators?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How do I view a stored procedure in sql server query?