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 is a trigger? : Sql dba

756

What program will open a mdb file?

674

Does sap use sql?

715

Is left join faster than inner join?

828

How do you optimize a stored procedure query?

730

Is postgresql a nosql database?

789

How do I save a stored procedure?

727

How do you concatenate in sql?

722

How do I count rows in sql?

735

What is structural independence and why is it important?

752

Can you inner join the same table?

705

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

859

What is clustered and nonclustered index in sql?

693

Is sqlite free?

714

Can we use join in subquery?

773