Tag: What are the types of subquery?

There are two types of sub-query – Correlated and Non-Correlated.

A correlated sub-query cannot be considered as an independent query, but it can refer the column in a table listed in the FROM the list of the main query.

A Non-Correlated subquery can be considered as an independent query and the output of subquery is substituted in the main query.