Which of the following is a correlated subquery ?
A. Uses the result of an inner query to determine the processing of an outer query
B. Uses the result of an outer query to determine the processing of an inner query
C. Uses the result of an inner query to determine the processing of an inner query
D. Uses the result of an outer query to determine the processing of an outer query
Answer:A
Which of the following is a correlated subquery ?
A. Uses the result of an inner query to determine the processing of an outer query B. Uses the result of an outer query to determine the processing of an inner query C. Uses the result of an inner query to determine the processing of an inner query D. Uses the result of an outer query to determine the processing of an outer query
Explanation: A ‘correlated sub-query’ is a term used for specific types of queries in SQL in computer databases. It is a sub-query (a query nested inside another query) that uses values from the outer query in its WHERE clause.