Question: what is difference between correlated query and subquery?
Answer: A subquery is a select statement that is embedded in a clause of another select statement. ... A Correlated subquery is a subquery that is evaluated once for each row processed by the outer query or main query.