how many no of table can be join in a sql query.
Answers were Sorted based on User's Feedback
Answer / ram
many number of tables can be join in a sql query by using 'join'
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / jo
In where clause u can write 254 subqueries and in from
clause u can write n number of queries
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / o.sridevi
many number of tables can create but not at a time one after one
| Is This Answer Correct ? | 0 Yes | 6 No |
is it necessary to write group by and order by clause together
What is partition in sql query?
What sql does db2 use?
How to return multiple records from procedure?
How do I audit the sql sent to the server?
What is a sql trace file?
I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.
What are the two virtual tables available at the time of database trigger execution?
How to add new employee details in an employee_details table with the following details
What is the difference between RDBMS and DBMS?
20 Answers Practical Viva Questions, Sapient, Stag Computers,
Talk about views
What is the maximum number of columns in sql table?
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)