Last updated:9/16/2020 4:31:22 AM
1 Answers
© Copyright © 2010 - 2021 MindStick Software Pvt. Ltd. All Rights Reserved
© Copyright © 2010 - 2021 MindStick Software Pvt. Ltd. All Rights Reserved
Anonymous User
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.