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 can windows applications connect to sql servers via odbc?
When multiple after triggers are attached to sql table, how to control the order of execution?
How will you optimize a stored procedure optimization?
What is dirty page?
Which are the new data types introduced in sql server 2008?
What is SQL Server?
Explain different types of index?
How do you load large data to the SQL server database?
What is #temp and @table variable in SQL server?
What are dml triggers and types of dml triggers?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
What do you need to connect php to sql server?
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)