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
How to loop through result set objects using odbc_fetch_row()?
How is foreign key related to primary key?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What new changes are being made in SQL Server?
What is the latest version of microsoft sql server?
What is the difference between online clustering and Offline clustering?
What is extended stored procedures?
How to truncate the log in sql server 2012? : sql server database administration
What is row_number function?
Define right outer join?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to throw custom exception in Stored Procedure?
What is the cpu pressure?
Explain about analysis services?