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.
Liked By
Write Answer
What are the types of subquery?
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
04-Jul-2019These 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.