DIPTENDU HUI

• Jan 28th, 2006

 

1.Subquery is nothing but a query inside a query which appears only after the WHERE clause of a select statement.

2.Two types of subquery is there:

a) Co-Related subquery

b) Non-Co-related subquery.

3. Use of subquery is to run or execute your subquery accoring to the best Execution plan available with Oracle.

Sheraz Baig

• Nov 22nd, 2013

 

Subquery is basically Query Withing Query.. and the Result of Subquery is used by Outer query and Subquery could be at any level its not level restricted...