Illustrates the term Correlated Subquery

Question

Illustrates the term Correlated Subquery?

Answer 1

Correlated Subquery is a subquery which is evaluated once for each row processed through the parent statement. Parent statement is, which can Select, Delete or Update. Employ CRSQ to answer multipart queries whose answer based on the value within each row processed through parent statement.