What are the types of subquery?

Total Post:51

Points:255
 37  View(s)
Ratings:
Rate this:
  1. Post:51

    Points:255
    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