What is difference between co-related sub query and nested sub query?
- 1 Answers
- 659 Views
- I also Faced
- E-Mail Answers
Answer Posted / Chandrakant Giri
A correlated subquery depends on outer query's columns, so it accesses them for each row of the outer query. A nested subquery does not depend on the outer query's columns and is processed before the outer query. In other words, a correlated subquery can be thought of as embedded inside the main query, while a nested subquery acts as a separate unit.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
