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 |
What are the different types of columns types constraints in the sql server?
What are basics of policy management?
How do I find query history in sql server?
How to use linked server?
How to generate create procedure script on an existing stored procedure?
what are candidate key, alternate key and composite key? : Sql server database administration
Why use sub query in sql server and list out types of sub queries?
What is function of CUBE ?
what are constraints? : Sql server database administration
What is a coalesce function?
How to Run a Query on a Remote SQL Server?
What are locks in sql?
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)