![](https://engineershub.in/profilepictures/44203/users/77647.jpg)
![](https://engineershub.in/profilepictures/44204/users/31650.jpg)
A correlated subquery is a subquery that uses the values of the outer query. In other words, it depends on the outer query for its values. Because of this dependency, a correlated subquery cannot be executed independently as a simple subquery. Moreover, a correlated subquery is executed repeatedly, once for each row evaluated by the outer query. The correlated subquery is also known as a repeating subquery.
Recommended Questions
Useful Files
Users Joined
![](https://engineershub.in/profilepics/default/users.png)
![](https://engineershub.in/profilepics/default/users.png)
![](https://engineershub.in/profilepics/default/users.png)
![](https://engineershub.in/profilepics/default/users.png)
![](https://engineershub.in/profilepics/default/users.png)
A correlated subquery is a subquery that uses the values of the outer query. In other words, it depends on the outer query for its values. Because of this dependency, a correlated subquery cannot be executed independently as a simple subquery. Moreover, a correlated subquery is executed repeatedly, once for each row evaluated by the outer query. The correlated subquery is also known as a repeating subquery.
![](https://engineershub.in/themes/ehthree/images/loader.gif)
![EngineersHub Logo](https://engineershub.in/themes/ehthree/images/ehh.png)