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 |
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are different types of table joins?
How to receive output values from stored procedures?
What are a database and a data warehouse?
Is the primary key column of a table an index in ms sql server?
what kind of lan types do you know? : Sql server database administration
Can a table have 2 primary keys?
What are the types of processing and explain each? : sql server analysis services, ssas
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
What happens if you are trying to access a schema not owned by you?
Explain sub-query?
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)