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

What are sql functions? Describe in brief different types of sql functions?

1009

Write a sql query to get the third highest salary of an employee from employee_table?

1026

what are sequences

1598

What is informix sql?

917

What is meant by <> in sql?

889

what is the difference between blob and text? : Sql dba

960

what are the advantages of mysql in comparison to oracle? : Sql dba

936

What's the procedure?

862

what is datawarehouse? : Sql dba

950

What is an oracle stored procedure?

984

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3515

what is normalization? : Sql dba

1014

Is sql database free?

923

How do you update f as m and m as f from the below table testtable?

1784

Does normalization improve performance?

977