In a correlated subquery,the DBMS must run the lower SELECT statement as a process that is nested within the upper SELECT statement.

Question

Quizplus · Accepted Answer

In a correlated subquery, the lower SELECT statement depends on the results of the outer SELECT statement, so it must be executed for each row returned by the outer query. This nesting behavior is what makes the subquery "correlated" to the outer query.

In a Correlated Subquery,the DBMS Must Run the Lower SELECT