Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / vikas trivedi

32 levels of nesting within a query is possible.

Is This Answer Correct ?    35 Yes 12 No

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

Answer / ravi

255 levels

Is This Answer Correct ?    24 Yes 9 No

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

Answer / pradeep

http://download.oracle.com/docs/cd/B19306_01/server.102/b142
00/queries007.htm

The below stated on above page from oracle

A subquery can contain another subquery. Oracle Database
imposes no limit on the number of subquery levels in the
FROM clause of the top-level query. You can nest up to 255
levels of subqueries in the WHERE clause.

Is This Answer Correct ?    8 Yes 1 No

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

Answer / slokh

FROM clause
A subquery can also be found in the FROM clause. These are
called inline views.

For example:

select suppliers.name, subquery1.total_amt
from suppliers,
(select supplier_id, Sum(orders.amount) as total_amt
from orders
group by supplier_id) subquery1,
where subquery1.supplier_id = suppliers.supplier_id;

In this example, we've created a subquery in the FROM
clause as follows:

(select supplier_id, Sum(orders.amount) as total_amt
from orders
group by supplier_id) subquery1

This subquery has been aliased with the name subquery1.
This will be the name used to reference this subquery or
any of its fields.

Limitations:

Oracle allows an unlimited number of subqueries in the FROM
clause.

Is This Answer Correct ?    10 Yes 5 No

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

Answer / shekaran04

Oracle imposes no limit on the number of SUB Queries levels
in the from clause

Is This Answer Correct ?    5 Yes 3 No

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

Answer / 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

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

Answer / john

32 number of Subquery

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Is This Answer Correct ?    3 Yes 3 No

Post New Answer



More SQL PLSQL Interview Questions

What are the types of join in sql?

0 Answers  


What is PL/SQL Records?

0 Answers  


How do I view a sql trace file?

0 Answers  


Is it possible to update views?

0 Answers  


What is break?

0 Answers  






a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,


What is microsoft t sql?

0 Answers  


How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,


What is a dynamic query?

0 Answers  


Explain the order of sql statement execution?

0 Answers  


what is an alias command? : Sql dba

0 Answers  


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  






Categories