How many levels can subqueries be nested in a FROM clause?
Answer Posted / sulochana
There is no limit on the no.of sub queries in the FROM clause.
in WHERE clause ,we can write upto 255 levels only..
Thanks & Regards,
Sulochana
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Why we use triggers in mysql?
What is difference between primary and secondary key?
what is single byte over head in oracle..?
What is sql architecture?
What are the different type of joins in sql?
How does postgresql compare to oracle/db2/ms sql server/informix?
what is the difference between char and varchar data types? : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Define a temp table?
How many types of sql are there?
What is sql basics?
What is rank function in sql?
What is the difference between a query and a report?
What is basic structure of pl sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba