Question · SQL and MySQL course · Module 8: Subqueries
Plain or correlated
How does a correlated subquery differ from a plain one?
Answer options
- A correlated one cannot run on its own, because it needs a value from the outer query
- A correlated one is always faster than a plain one
- A plain one references columns of the outer query, a correlated one does not
- A correlated one may appear only in SELECT, a plain one only in WHERE
You can check the correct answer by solving this task in the CodeWorlds game.