Database - Advanced SQL - Discussion
Discussion Forum : Advanced SQL - True or False (Q.No. 12)
12.
A correlated subquery is where the outer query depends on data from the inner query.
Discussion:
6 comments Page 1 of 1.
Parag Vyas said:
8 years ago
The inner query is dependent on the outer query. Because correlated means if outer is satisfied than inner will get satisfied by the the result of outer query. So it will be definitely false.
Rahul said:
1 decade ago
Correlated sub query, inner query is the one which executes first right, so outer query depends on inner query.
Adesh said:
1 decade ago
A correlated subquery is where the outer query depends on data from the inner query.
This will be true.
This will be true.
Aaru said:
1 decade ago
In nested the outer query is depended on inner query's result. While in correlated query its revers.
Sree said:
9 years ago
The answer is true.
The correlated subquery the outer query works corresponding to the inner query.
The correlated subquery the outer query works corresponding to the inner query.
Ashu said:
1 decade ago
Is there a difference between nested and correlated query ?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers