There is no limit on the no.of sub queries in the FROM clause. in WHERE

How many levels can subqueries be nested in a FROM clause?

Question Posted / sulochana

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

Please Help Members By Posting Answers For Below Questions

Is pl sql useful?

966

Is it mandatory for the primary key to be given a value when a new record is inserted?

1187

What is difference between mysql and postgresql?

1119

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

952

How to write pl sql program in mysql command prompt?

1068

What happens when a trigger is associated to a view?

896

What are the most important characteristics of pl/sql?

1134

What is a database trigger?

1050

What are triggers and its types?

1041

what is schema? : Sql dba

1026

What are local and global variables and their differences?

1075

How to assign sql query results to pl sql variables?

1050

What is the difference between the conventional and direct path loads? : aql loader

1374

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1104

Mention what does the hierarchical profiler does?

1065