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

Why is the cursor important?

1078

Why do we use set serveroutput on?

1011

What are the types of functions in sql?

1064

How many sql commands are there?

1158

explain mysql aggregate functions. : Sql dba

1032

what is auto increment? : Sql dba

1049

Is mariadb a nosql database?

1098

what are properties of a transaction? : Sql dba

1134

Define commit, rollback and savepoint?

1081

what is a composite key ? : Sql dba

1101

What is a natural join?

1140

Where not exists in sql?

1032

What is sql query optimization?

1192

Can delete statement be rollbacked?

1031

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1046