Home > DeveloperSection > Interviews > What are the types of subquery?
 Ask Question

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

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved

DO YOU WISH TO IMPROVE YOUR BUSINESS ?

Once you’ve signed up as a user for a sponsorship on MindStick network, you will receive sponsored posting opportunities to apply for. It’s a great way to promote your product as a brand.

Yes, help me to improve my business No thanks x