What are the types of subquery?

There are two types of subquery – Correlated and Non-Correlated.

 

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

 

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