What are the types of subquery?

Total Post:55

Points:275

 159  View(s)
Ratings:
Rate this:
  1. What are the types of subquery?

    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.

      Modified On Jul-04-2019 11:25:50 PM

Answer