1 Answers
A correlated subquery is also a sort of subquery reliant on another query. Each subquery is executed a single time for every row of the outer query. You can also understand correlated subqueries as those queries, which are used for row by row processing by the parent statement. Here, the parent statement can be SELECT, UPDATE, or DELETE statement.