What is difference between subquery and correlated subquery with example?

Subquery : Subquery is query within query.The output of outer query is assigned to the column which is used in where condition of outer query.The … Continue reading What is difference between subquery and correlated subquery with example?