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 meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
Tell me about joins in database system and explain each in detail.
0 Answers Axtria, ITC Indian Tobacco Company,
Write a SQL queries on Self Join and Inner Join.
Explain couple pf features of SQL server
What language is sql server written in?
How do I find the sql server instance name?
What is the sql case statement used for? Explain with an example?
Difference between aggregate functions of sql?
How do I find the transaction log size in sql server?
what type of indexes physically sort data?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN 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)