Types of Sub-Queries

The difference between an uncorrelated sub-query, which runs once on its own, and a correlated sub-query, which runs once for each row of the outer query.

Updated

Cheat sheet: Types of Sub-Queries
Category
SQL
Level
Journeyman
Tags
mysql, sql