What are the types of subquery?

Question

Anonymous User · Answer

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.

interview

What are the types of subquery?

Can you answer this question?

1 Answers