When we write a subquery in such a way that inner subquery and outer main query are interdependent, then we call it s correlated Sub query. In this case, for executing every row of inner query, the outer query is also executed. The inner query needs data from the outer query for its execution.
select * from tblInvoiceDetail where articleid in (select articleid from tblArticlemaster where doi like ‘RKCbp%’)
In a non-correlated subquery, inner subquery has no dependency on outer query.
Uncorrelated Subquery:
An uncorrelated subquery is a subquery that can be executed independently of the outer query. It does not reference any columns from the outer query. The subquery is evaluated only once and its result is used by the outer query. The result of the subquery is typically a single value or a single row. Uncorrelated subqueries are evaluated first, and then their results are used by the outer query.
Correlated Subquery:
A correlated subquery is a subquery that is executed for each row of the outer query. It references one or more columns from the outer query and relies on the values from the outer query to produce results. The subquery is evaluated repeatedly, once for each row of the outer query. The result of the subquery can be a single value or multiple rows. Correlated subqueries are evaluated for each row of the outer query.
