Skip to content
Home » sql subquery vs correlated subquery

sql subquery vs correlated subquery

What is Correlated Subquery in SQL?

A correlated subquery is a subquery that uses the values of the outer query  and it is evaluated for each row processed by the outer query 

A correlated subquery  always depends on outer query for its value. Because of this dependency, a correlated subquery cannot be executed independently as a simple subquery .

 3,409 total views,  6 views today