Question · SQL and MySQL course · Module 8: Subqueries

Map of tools

Which tool best answers the question 'does a related row exist at all'?

Answer options

  • A derived table in FROM
  • UNION ALL
  • A scalar subquery with AVG
  • EXISTS / NOT EXISTS

You can check the correct answer by solving this task in the CodeWorlds game.