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 will you add a dimension to cube? : sql server analysis services, ssas
What is join and name different type of joins?
Explain sql server authentication modes?
What is the maximum size of column in sql server?
Which index created when Create Index on table(col), Why
What is apply operator in sql?
What are the differences between stored procedure and the dynamic sql?
What is compound operators?
What is xdr?
Do you know the different ddl commands in sql?
what's the difference between a primary key and a unique key? : Sql server database administration
How will you collect the date from current date to last older 6 days date in sql server 2005
Oracle (3253)
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)