correlated subquery in oracle

[lopez]

hi dere,
i'm new to oracle..
can anybody help me with correlated subquery
thanks in advance.
regards,
lopez
(knowledge is power)

[Saii]

What exactly are you looking for?

[aswath]

What exactly are you looking for?

hi,
i know what a subquery is... however i have never come across a word called correlated subquery.. can u plz tell me what is that.
thanks in advance.....

[amitpatel66]

hi,
i know what a subquery is... however i have never come across a word called correlated subquery.. can u plz tell me what is that.
thanks in advance.....

Correlated Sub-Query is something that gets executed once for each record of outer main query.

Example:

[code=oracle]

SELECT MIN(x.salary) FROM emp x WHERE 2 > (SELECT COUNT(*) FROM emp WHERE salary > x.salary);

[/code]

The above code in which the inner sub query is callced correlated because if you check the WHERE condition where I have compared salary with salary column of outer MAIN query table.

[lopez]

Correlated Sub-Query is something that gets executed once for each record of outer main query.

Example:

[code=oracle]

SELECT MIN(x.salary) FROM emp x WHERE 2 > (SELECT COUNT(*) FROM emp WHERE salary > x.salary);

[/code]

The above code in which the inner sub query is callced correlated because if you check the WHERE condition where I have compared salary with salary column of outer MAIN query table.

got it pal.....
thanks........