Correlated Subqueries
Learn Correlated Subqueries (Subqueries, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A correlated subquery refers to a column of the outer query, so it is logically re-evaluated for each outer row. It cannot run on its own because it depends on the outer alias.