Question · SQL and MySQL course · Module 8: Subqueries

Missing derived table alias

What happens in MySQL if a derived table in the FROM clause is not given an alias?

Answer options

  • The query works but returns only the first row
  • MySQL automatically removes the derived table
  • An alias is never needed in MySQL
  • The query reports an error - MySQL requires an alias for a derived table

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