What are the types of subquery?
1180
04-Jul-2019
Updated on 16-Sep-2020
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.