how many joins we can write if at all we have n no of
tables
Answers were Sorted based on User's Feedback
Answer / soni
To join n no. of tables ,we required n-1 join conditions
| Is This Answer Correct ? | 31 Yes | 3 No |
Answer / deepak
The minimum number of joins required are N-1. Maximum can
be up to 256.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / shivaraj
n no of As many u want and complecation of the query
| Is This Answer Correct ? | 2 Yes | 12 No |
How to write a query with a left outer join in ms sql server?
What are the types of joins in sql?
Explain what is the use of custom fields in report?
Why main is user defined function?
How to change location of errorlog in SQL?
What are SSL and TSL protocols?
how do we insert 100 records at a time in a table without using for loop in database
How many types of local tables are there in sql server?
How to Run a Query on a Remote SQL Server?
What is coalesce and check constraint in sql server?
what stored procedure can you use to display the current processes? : Sql server administration
Why use sub query in sql server and list out types of sub queries?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)