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 |
Does sql backup shrink transaction log?
Name the tables where characteristics of Package, procedure and functions are stored ?
can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?
What are views in sql?
How many rows will return from dual table?
How to find last day of the month in sql query
Can a view be updated/inserted/deleted?If Yes under what conditions?
What is time based sql injection?
Is stored procedure faster than query?
What is the primary key?
How do you add a column to a table?
What will you get by the cursor attribute sql%found?