Skip to content
Home » subquery vs correlated subquery

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,380 total views