What is difference between subquery and correlated subquery?

A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer… Read More »SQL Correlated Subquery