Answers

Question and Answer:

  Home  Database Analyst

⟩ Tell us what are the different types of subqueries?

There are two types of subqueries: correlated and uncorrelated.

An uncorrelated subquery is a independent query whose output is substituted into the main query. A correlated subquery, on the other hand, uses values from the outer query and therefore depends on the outer query. Such a subquery executes repeatedly, once for each row that is selected by the outer query.

 150 views

More Questions for you: