What are the types of subquery?
Ask by Anonymous User
Updated 16 Sep 2020
These are two types of subquery – Correlated and Non-Correlated.
The correlated subquery 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.
The Non-Correlated subquery can be considered as an independent query and the output of subquery are substituted in the main query.