What is "correlated subqueries"?

- In "correlated subqueries", the result of outer query is passed to the subquery and the subquery runs for each row.

What is "correlated sub queries"?

A correlated sub query is a type of sub query. Unlike sub query, a correlated sub query is dependent upon the outer query, which returns a value. When a reference to the outer query is found in the sub query, then the outer query will execute first, and the result will be returned to the correlated sub query. The sub query is executed alter for every row that is selected in the outer query.