What do you understand by correlated subqueries inn DBMA?

All QuestionsCategory: DatabaseWhat do you understand by correlated subqueries inn DBMA?
chetan shidling asked 4 years ago

I need short information.

1 Answers
chetan shidling answered 4 years ago

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.