how many joins we can write if at all we have n no of
tables

Answer Posted / soni

To join n no. of tables ,we required n-1 join conditions

Is This Answer Correct ?    31 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different types of backups available in sql server? : sql server database administration

523


Why use “in” clause in sql server?

560


Explain nested stored procedure. Syntax and an example for create nested stored procedure?

534


What is full outer join in sql server joins?

571


Can truncate be rolled back?

546






What is schemabinding a view?

534


Explain can SSRS reports Cache results?

112


Do you know how to store and query spatial data?

609


What are transactions and its controls?

621


How to download and install sql server 2005 books online?

544


How to write a query with a full outer join in ms sql server?

564


How many categories of functions based their return modes?

598


How use inner join in sql server?

617


Will the writetext statement activate a trigger?

572


What are orphan records?

550