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.