InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What do you mean by SQL Correlated Subqueries? |
|
Answer» A correlated sub-QUERY is a sub-query that is dependent on another query. Sub-queries that are EXECUTED for each row of an outer query are referred to as correlated sub-queries. For each row in the outer query, each sub-query is executed once. Correlated sub-queries can alternatively be thought of as queries that the PARENT statement uses for row-by-row PROCESSING. The parent statement, in this case, MIGHT be SELECT, UPDATE, or DELETE. |
|