Row-by-row processing is done with related subqueries. For each row in the outer query, each subquery is run once. For each row processed by the parent statement, a connected subquery is examined once. A SELECT, UPDATE, or DELETE statement can be the parent statement.