how many no of table can be join in a sql query.
- 4 Answers
- 8656 Views
- I also Faced
- E-Mail Answers
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 |
Can you rollback after commit?
What is clause?
What is synonyms?
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
What is the difference between inner join and natural join?
What is Primary Key?
what is meant by DML?
What is nvarchar in sql?
How to run sql statements through the web interface?
Is sql between inclusive?
How to set up sql*plus output format in oracle?
What do you understand by pl/sql packages?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
