1. Required in those cases where requisted data are not known and always depend on inner query
2. In sub query the inner query is executed only once. Depeding upon the results of inner query , outer query is evaluated.
Correlated subquery: -
1. Outer depend on inner query and inner query depend on outer query
2. In correlated subquery the inner query is evaluated once for each row processed by the parent statement or outer query.